APPS.OKS_IMPORT_INSERT dependencies on OKS_SUBSCR_HEADER_B

Line 1972: INTO OKS_SUBSCR_HEADER_B

1968: l_stmt_num := 30;
1969:
1970: INSERT ALL
1971: WHEN (1=1) THEN
1972: INTO OKS_SUBSCR_HEADER_B
1973: (ID
1974: ,CLE_ID
1975: ,DNZ_CHR_ID
1976: ,INSTANCE_ID

Line 2028: ,OKS_SUBSCR_HEADER_B SUB_HDR

2024: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2025: FROM OKC_K_LINES_B OKCLINB
2026: ,OKS_INT_LINE_STG_TEMP OLSTG
2027: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2028: ,OKS_SUBSCR_HEADER_B SUB_HDR
2029: ,OKC_K_HEADERS_ALL_B OKCHDRB
2030: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
2031: AND HDRSTG.INTERFACE_STATUS ='S'
2032: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 2086: ,OKS_SUBSCR_HEADER_B SUB_HDR_1

2082:
2083: FROM OKC_K_LINES_B OKCLINB
2084: ,OKS_INT_LINE_STG_TEMP OLSTG
2085: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2086: ,OKS_SUBSCR_HEADER_B SUB_HDR_1
2087: ,OKS_SUBSCR_HEADER_B SUB_HDR_2
2088: ,OKS_SUBSCR_HEADER_TL SUB_HDR_TL
2089: ,OKC_K_HEADERS_ALL_B OKCHDRB
2090: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 2087: ,OKS_SUBSCR_HEADER_B SUB_HDR_2

2083: FROM OKC_K_LINES_B OKCLINB
2084: ,OKS_INT_LINE_STG_TEMP OLSTG
2085: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2086: ,OKS_SUBSCR_HEADER_B SUB_HDR_1
2087: ,OKS_SUBSCR_HEADER_B SUB_HDR_2
2088: ,OKS_SUBSCR_HEADER_TL SUB_HDR_TL
2089: ,OKC_K_HEADERS_ALL_B OKCHDRB
2090: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
2091: AND HDRSTG.INTERFACE_STATUS ='S'