APPS.OKS_IMPORT_TEST_INSERT dependencies on OKC_K_HEADERS_ALL_B

Line 265: OKC_K_HEADERS_ALL_B H

261: ,l_batch_id
262: ,'OKS_IMPORT'
263: ,'Doc'||l_batch_id
264: FROM
265: OKC_K_HEADERS_ALL_B H
266: ,OKS_K_HEADERS_B HS
267: ,OKC_K_HEADERS_TL HL
268: ,OKC_K_PARTY_ROLES_B PTY
269: ,HZ_PARTIES HZP

Line 460: OKC_K_HEADERS_ALL_B H

456: ,LS.AVERAGING_INTERVAL AS AVERAGING_INTERVAL
457: ,LS.SETTLEMENT_INTERVAL AS SETTLEMENT_INTERVAL
458: ,LS.TERMN_METHOD AS USAGE_TERMINATION_METHOD
459: FROM
460: OKC_K_HEADERS_ALL_B H
461: ,OKC_K_LINES_V LINE
462: ,OKS_K_LINES_V LS
463: ,OKC_LINE_STYLES_V LTYST
464: ,OKC_K_ITEMS KITEMS

Line 542: ,OKC_K_HEADERS_ALL_B H

538: ,OSC.SALES_GROUP_ID AS SALESGROUP_ID
539: ,SCT.NAME AS SALES_CREDIT_TYPE
540: ,PERCENT
541: FROM OKS_K_SALES_CREDITS OSC
542: ,OKC_K_HEADERS_ALL_B H
543: ,JTF_RS_SALESREPS SLSREPID
544: ,JTF_RS_RESOURCE_EXTNS_VL SLSREPNAME
545: ,OE_SALES_CREDIT_TYPES SCT
546: ,OKS_HEADERS_INTERFACE OHI

Line 657: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
659: ,CSI_ITEM_INSTANCES CSIITMINST
660: ,HZ_CUST_ACCOUNTS CUSTACC
661: ,MTL_SYSTEM_ITEMS_B_kfv MTLSYSITM

Line 751: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
754: ,OKS_K_LINES_TL OKSLINTL
755: ,OKC_K_LINES_B OKCLINB_LINE

Line 807: ,OKC_K_HEADERS_ALL_B OKCHDRB

803:
804: FROM JTF_NOTES_B JTFNTB
805: ,JTF_NOTES_TL JTFNTL
806: ,OKS_HEADERS_INTERFACE HDRINT
807: ,OKC_K_HEADERS_ALL_B OKCHDRB
808:
809: WHERE JTFNTB.SOURCE_OBJECT_CODE = 'OKS_HDR_NOTE'
810: AND JTFNTB.JTF_NOTE_ID = JTFNTL.JTF_NOTE_ID
811: AND JTFNTL.LANGUAGE = USERENV('LANG')

Line 845: ,OKC_K_HEADERS_ALL_B OKCHDRB

841:
842: FROM JTF_NOTES_B JTFNTB
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