[Home] [Help]
67: SELECT OKS_HEADERS_INT_BATCH_S.nextval into l_batch_id from dual;
68:
69: l_stmt_num := 20;
70:
71: INSERT INTO OKS_HEADERS_INTERFACE
72: (
73: HEADER_INTERFACE_ID
74: ,CONTRACT_NUMBER
75: ,CONTRACT_NUMBER_MODIFIER
486: AND R.DIRECTIONAL_FLAG = 'F') SHIPTOCONTNAME
487: ,QP_LIST_HEADERS_VL PRLNAME
488: ,OKX_RULES_V ACCTRULE
489: ,OKX_RULES_V INVRULE
490: ,OKS_HEADERS_INTERFACE OHI
491: WHERE
492: H.ID = LINE.CHR_ID
493: AND LINE.LSE_ID IN (1,12,14,19,46)
494: AND LINE.ID = LS.CLE_ID
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
547: WHERE H.ID = OSC.CHR_ID
548: AND OSC.CLE_ID IS NULL
549: AND OSC.CTC_ID = SLSREPID.SALESREP_ID
550: AND SLSREPID.ORG_ID = H.AUTHORING_ORG_ID
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
659: ,CSI_ITEM_INSTANCES CSIITMINST
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
756: ,OKC_K_LINES_B OKCLINB_SUBLINE
802: ,JTFNTB.ENTERED_DATE ENTERED_DATE
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
840: ,JTFNTB.ENTERED_DATE ENTERED_DATE
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: