APPS.OKS_IMPORT_INSERT dependencies on OKS_K_LINES_B

Line 1749: INTO OKS_K_LINES_B

1745: l_stmt_num := 10;
1746:
1747: INSERT ALL
1748: WHEN (1=1) THEN
1749: INTO OKS_K_LINES_B
1750: (ID
1751: ,CLE_ID
1752: ,DNZ_CHR_ID
1753: ,ACCT_RULE_ID

Line 1887: FROM OKS_K_LINES_B OKSLB

1883: ,OKSLB.PM_SCH_EXISTS_YN AS PM_SCH_EXISTS_YN
1884: ,OKSLB.PM_CONF_REQ_YN AS PM_CONF_REQ_YN
1885: ,LIN.LINE_INTERFACE_ID
1886: ,LIN.LINE_NUMBER
1887: FROM OKS_K_LINES_B OKSLB
1888: , OKS_INT_LINE_STG_TEMP LIN
1889: WHERE OKSLB.CLE_ID = LIN.REFERENCE_TEMPLATE_ID) COV_IN_QUERY
1890: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
1891: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 1947: ,OKS_K_LINES_B OKSLINB

1943: ,OLSTG.INVOICE_TEXT INVOICE_TEXT
1944: FROM OKS_INT_LINE_STG_TEMP OLSTG
1945: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1946: ,OKC_K_HEADERS_ALL_B OKCHDRB
1947: ,OKS_K_LINES_B OKSLINB
1948: ,OKC_K_LINES_B OKCLINB
1949:
1950: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
1951: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 2265: INTO OKS_K_LINES_B

2261: l_stmt_num := 20;
2262:
2263: INSERT ALL
2264: WHEN (1=1) THEN
2265: INTO OKS_K_LINES_B
2266: (ID
2267: ,CLE_ID
2268: ,DNZ_CHR_ID
2269: ,INV_PRINT_FLAG

Line 2376: ,OKS_K_LINES_B OKSLINB

2372: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2373: ,OKC_K_HEADERS_aLL_B OKCHDRB
2374: ,OKC_K_LINES_B OKCLINB_LINE
2375: ,OKC_K_LINES_B OKCLINB_SUBLINE
2376: ,OKS_K_LINES_B OKSLINB
2377: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2378: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2379:
2380: WHERE OCLI.COVERED_LEVEL_INTERFACE_ID = OCLVLSTG.COVERED_LEVEL_INTERFACE_ID

Line 2502: ,OKS_K_LINES_B OKSLINB

2498: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2499: ,OKC_K_HEADERS_aLL_B OKCHDRB
2500: ,OKC_K_LINES_B OKCLINB_LINE
2501: ,OKC_K_LINES_B OKCLINB_SUBLINE
2502: ,OKS_K_LINES_B OKSLINB
2503: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2504: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2505:
2506: WHERE OCLI.COVERED_LEVEL_INTERFACE_ID = OCLVLSTG.COVERED_LEVEL_INTERFACE_ID

Line 2645: INTO OKS_K_LINES_B

2641: l_stmt_num :=60;
2642:
2643: INSERT ALL
2644: WHEN (1=1 ) THEN
2645: INTO OKS_K_LINES_B
2646: (ID
2647: ,CLE_ID
2648: ,DNZ_CHR_ID
2649: ,USAGE_EST_YN

Line 2857: ,OKS_K_LINES_B OKSLINB

2853: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2854: ,OKC_K_HEADERS_ALL_B OKCHDRB
2855: ,OKC_K_LINES_B OKCLINB_SUBLINE
2856: ,OKC_K_LINES_B OKCLINB_LINE
2857: ,OKS_K_LINES_B OKSLINB
2858:
2859: WHERE OUSGCNTINT.USAGE_COUNTER_INTERFACE_ID = OUSGCNTSTG.USAGE_COUNTER_INTERFACE_ID
2860: AND OUSGCNTSTG.LINE_INTERFACE_ID =OLSTG.LINE_INTERFACE_ID
2861: AND OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID