APPS.OKS_IMPORT_INSERT dependencies on OKS_K_LINES_B

Line 1757: INTO OKS_K_LINES_B

1753: l_stmt_num := 10;
1754:
1755: INSERT ALL
1756: WHEN (1=1) THEN
1757: INTO OKS_K_LINES_B
1758: (ID
1759: ,CLE_ID
1760: ,DNZ_CHR_ID
1761: ,ACCT_RULE_ID

Line 1895: FROM OKS_K_LINES_B OKSLB

1891: ,OKSLB.PM_SCH_EXISTS_YN AS PM_SCH_EXISTS_YN
1892: ,OKSLB.PM_CONF_REQ_YN AS PM_CONF_REQ_YN
1893: ,LIN.LINE_INTERFACE_ID
1894: ,LIN.LINE_NUMBER
1895: FROM OKS_K_LINES_B OKSLB
1896: , OKS_INT_LINE_STG_TEMP LIN
1897: WHERE OKSLB.CLE_ID = LIN.REFERENCE_TEMPLATE_ID) COV_IN_QUERY
1898: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
1899: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 1955: ,OKS_K_LINES_B OKSLINB

1951: ,OLSTG.INVOICE_TEXT INVOICE_TEXT
1952: FROM OKS_INT_LINE_STG_TEMP OLSTG
1953: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1954: ,OKC_K_HEADERS_ALL_B OKCHDRB
1955: ,OKS_K_LINES_B OKSLINB
1956: ,OKC_K_LINES_B OKCLINB
1957:
1958: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
1959: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 2275: INTO OKS_K_LINES_B

2271: l_stmt_num := 20;
2272:
2273: INSERT ALL
2274: WHEN (1=1) THEN
2275: INTO OKS_K_LINES_B
2276: (ID
2277: ,CLE_ID
2278: ,DNZ_CHR_ID
2279: ,INV_PRINT_FLAG

Line 2386: ,OKS_K_LINES_B OKSLINB

2382: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2383: ,OKC_K_HEADERS_aLL_B OKCHDRB
2384: ,OKC_K_LINES_B OKCLINB_LINE
2385: ,OKC_K_LINES_B OKCLINB_SUBLINE
2386: ,OKS_K_LINES_B OKSLINB
2387: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2388: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2389:
2390: WHERE OCLI.COVERED_LEVEL_INTERFACE_ID = OCLVLSTG.COVERED_LEVEL_INTERFACE_ID

Line 2512: ,OKS_K_LINES_B OKSLINB

2508: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2509: ,OKC_K_HEADERS_aLL_B OKCHDRB
2510: ,OKC_K_LINES_B OKCLINB_LINE
2511: ,OKC_K_LINES_B OKCLINB_SUBLINE
2512: ,OKS_K_LINES_B OKSLINB
2513: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2514: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2515:
2516: WHERE OCLI.COVERED_LEVEL_INTERFACE_ID = OCLVLSTG.COVERED_LEVEL_INTERFACE_ID

Line 2655: INTO OKS_K_LINES_B

2651: l_stmt_num :=60;
2652:
2653: INSERT ALL
2654: WHEN (1=1 ) THEN
2655: INTO OKS_K_LINES_B
2656: (ID
2657: ,CLE_ID
2658: ,DNZ_CHR_ID
2659: ,USAGE_EST_YN

Line 2867: ,OKS_K_LINES_B OKSLINB

2863: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2864: ,OKC_K_HEADERS_ALL_B OKCHDRB
2865: ,OKC_K_LINES_B OKCLINB_SUBLINE
2866: ,OKC_K_LINES_B OKCLINB_LINE
2867: ,OKS_K_LINES_B OKSLINB
2868:
2869: WHERE OUSGCNTINT.USAGE_COUNTER_INTERFACE_ID = OUSGCNTSTG.USAGE_COUNTER_INTERFACE_ID
2870: AND OUSGCNTSTG.LINE_INTERFACE_ID =OLSTG.LINE_INTERFACE_ID
2871: AND OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID