PJC_BC_PACKETS_T_HEADER_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name
PROCESS_ID SOURCE_HEADER_ID_CHAR_1 SOURCE_HEADER_ID_CHAR_2 SOURCE_HEADER_ID_CHAR_3 SOURCE_HEADER_ID_CHAR_4 SOURCE_HEADER_ID_NUM_1 SOURCE_HEADER_ID_NUM_2 SOURCE_HEADER_ID_NUM_3 SOURCE_HEADER_ID_NUM_4 BATCH_ID

Query

SQL_Statement

SELECT DISTINCT -1 PROCESS_ID, NULL SOURCE_HEADER_ID_CHAR_1, NULL SOURCE_HEADER_ID_CHAR_2, NULL SOURCE_HEADER_ID_CHAR_3, NULL SOURCE_HEADER_ID_CHAR_4, bc.DOCUMENT_HEADER_ID SOURCE_HEADER_ID_NUM_1, NULL SOURCE_HEADER_ID_NUM_2, NULL SOURCE_HEADER_ID_NUM_3, NULL SOURCE_HEADER_ID_NUM_4, bc.BATCH_ID BATCH_ID FROM PJC_BC_PACKETS_T bc WHERE bc.packet_id = -1 AND bc.parent_bc_packet_id is null AND bc.status_code ='P'