APPS.OKS_IMPORT_TEST_INSERT dependencies on OKS_LINES_INTERFACE

Line 341: INSERT INTO OKS_LINES_INTERFACE

337: FND_FILE.put_line(FND_FILE.OUTPUT, 'Batch Id '|| l_batch_id ||' inserted into interface tables');
338:
339: l_stmt_num := 30;
340:
341: INSERT INTO OKS_LINES_INTERFACE
342: (
343: LINE_INTERFACE_ID
344: ,HEADER_INTERFACE_ID
345: ,LINE_NUMBER

Line 654: FROM OKS_LINES_INTERFACE LININT

650: , OKSLINB.PRICE_UOM PRICE_UOM
651: , OKCLINB_subline.PRICE_NEGOTIATED SUBTOTAL
652: , OKSLINB.TAX_AMOUNT TAX_AMOUNT
653:
654: FROM OKS_LINES_INTERFACE LININT
655: ,OKS_HEADERS_INTERFACE HDRINT
656:
657: ,OKC_K_HEADERS_ALL_B OKCHDRB
658: ,OKC_K_ITEMS OKCITM

Line 749: FROM OKS_LINES_INTERFACE LININT

745: ,OKSLINB.USAGE_EST_METHOD ESTIMATION_METHOD
746: ,OKSLINB.USAGE_EST_START_DATE ESTIMATION_START_DATE
747: ,OKSLINB.LEVEL_YN LEVEL_YN
748: ,OKSLINB.TAX_AMOUNT TAX_AMOUNT
749: FROM OKS_LINES_INTERFACE LININT
750: ,OKS_K_LINES_B OKSLINB
751: ,OKC_K_HEADERS_ALL_B OKCHDRB
752: ,OKS_HEADERS_INTERFACE HDRINT
753: ,OKC_K_LINES_TL OKCLINTL

Line 847: ,OKS_LINES_INTERFACE LININT

843: ,JTF_NOTES_TL JTFNTL
844: ,OKS_HEADERS_INTERFACE HDRINT
845: ,OKC_K_HEADERS_ALL_B OKCHDRB
846: ,OKC_K_LINES_B OKCLINB
847: ,OKS_LINES_INTERFACE LININT
848:
849: WHERE LININT.HEADER_INTERFACE_ID = HDRINT.HEADER_INTERFACE_ID
850: AND JTFNTB.SOURCE_OBJECT_CODE = 'OKS_COV_NOTE'
851: AND JTFNTB.JTF_NOTE_ID = JTFNTL.JTF_NOTE_ID