DBA Data[Home] [Help]

APPS.OKS_ENT_UTIL_PVT dependencies on OKX_CUSTOMER_PRODUCTS_V

Line 597: OKX_CUSTOMER_PRODUCTS_V PDT

593: SELECT PDT.ID1,
594: PDT.QUANTITY
595: FROM OKC_K_LINES_B LIN,
596: OKC_K_ITEMS ITM,
597: OKX_CUSTOMER_PRODUCTS_V PDT
598: WHERE LIN.ID = ITM.CLE_ID
599: AND ITM.OBJECT1_ID1 = PDT.ID1
600: AND ITM.OBJECT1_ID2 = PDT.ID2
601: AND ITM.JTOT_OBJECT1_CODE = 'OKX_CUSTPROD'

Line 628: OKX_CUSTOMER_PRODUCTS_V PDT,

624: PDT.INSTALL_SITE_USE_ID,
625: SIT.NAME PARTY_SITE_NAME
626: FROM OKC_K_LINES_B LIN,
627: OKC_K_ITEMS ITM,
628: OKX_CUSTOMER_PRODUCTS_V PDT,
629: OKX_CUSTOMER_ACCOUNTS_V CUS,
630: OKX_PARTIES_V PTY,
631: OKX_PARTY_SITES_V SIT --OKX_PARTY_SITE_USES_V SIT
632: WHERE LIN.ID = ITM.CLE_ID

Line 647: CSI_ITEM_INSTANCES PDT, --OKX_CUSTOMER_PRODUCTS_V PDT,

643: PDT.install_location_id install_location_id, --PDT.INSTALL_SITE_USE_ID,
644: SIT.NAME PARTY_SITE_NAME
645: FROM OKC_K_LINES_B LIN,
646: OKC_K_ITEMS ITM,
647: CSI_ITEM_INSTANCES PDT, --OKX_CUSTOMER_PRODUCTS_V PDT,
648: OKX_CUSTOMER_ACCOUNTS_V CUS,
649: OKX_PARTIES_V PTY,
650: OKX_PARTY_SITES_V SIT --OKX_PARTY_SITE_USES_V
651: WHERE LIN.ID = ITM.CLE_ID