APPS.OKS_IMPORT_INSERT dependencies on OKS_SUBSCR_HEADER_B

Line 1964: INTO OKS_SUBSCR_HEADER_B

1960: l_stmt_num := 30;
1961:
1962: INSERT ALL
1963: WHEN (1=1) THEN
1964: INTO OKS_SUBSCR_HEADER_B
1965: (ID
1966: ,CLE_ID
1967: ,DNZ_CHR_ID
1968: ,INSTANCE_ID

Line 2020: ,OKS_SUBSCR_HEADER_B SUB_HDR

2016: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2017: FROM OKC_K_LINES_B OKCLINB
2018: ,OKS_INT_LINE_STG_TEMP OLSTG
2019: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2020: ,OKS_SUBSCR_HEADER_B SUB_HDR
2021: ,OKC_K_HEADERS_ALL_B OKCHDRB
2022: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
2023: AND HDRSTG.INTERFACE_STATUS ='S'
2024: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 2078: ,OKS_SUBSCR_HEADER_B SUB_HDR_1

2074:
2075: FROM OKC_K_LINES_B OKCLINB
2076: ,OKS_INT_LINE_STG_TEMP OLSTG
2077: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2078: ,OKS_SUBSCR_HEADER_B SUB_HDR_1
2079: ,OKS_SUBSCR_HEADER_B SUB_HDR_2
2080: ,OKS_SUBSCR_HEADER_TL SUB_HDR_TL
2081: ,OKC_K_HEADERS_ALL_B OKCHDRB
2082: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 2079: ,OKS_SUBSCR_HEADER_B SUB_HDR_2

2075: FROM OKC_K_LINES_B OKCLINB
2076: ,OKS_INT_LINE_STG_TEMP OLSTG
2077: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2078: ,OKS_SUBSCR_HEADER_B SUB_HDR_1
2079: ,OKS_SUBSCR_HEADER_B SUB_HDR_2
2080: ,OKS_SUBSCR_HEADER_TL SUB_HDR_TL
2081: ,OKC_K_HEADERS_ALL_B OKCHDRB
2082: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
2083: AND HDRSTG.INTERFACE_STATUS ='S'