DBA Data[Home] [Help]

APPS.OKS_ENT_UTIL_PVT dependencies on OKX_CUSTOMER_ACCOUNTS_V

Line 629: OKX_CUSTOMER_ACCOUNTS_V CUS,

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
633: AND ITM.OBJECT1_ID1 = PDT.ID1

Line 648: OKX_CUSTOMER_ACCOUNTS_V CUS,

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
652: AND ITM.OBJECT1_ID1 = PDT.Inventory_item_id --PDT.ID1

Line 1002: OKX_CUSTOMER_ACCOUNTS_V CT

998: CURSOR l_cust_csr IS
999: SELECT IT.OBJECT1_ID1, CT.NAME
1000: FROM OKC_K_LINES_B KL,
1001: OKC_K_ITEMS IT,
1002: OKX_CUSTOMER_ACCOUNTS_V CT
1003: WHERE KL.ID = IT.CLE_ID
1004: AND IT.OBJECT1_ID1 = CT.ID1
1005: AND IT.OBJECT1_ID2 = CT.ID2
1006: AND IT.JTOT_OBJECT1_CODE = 'OKX_CUSTACCT'