DBA Data[Home] [Help]

APPS.OKS_ENT_UTIL_PVT dependencies on OKX_PARTIES_V

Line 630: OKX_PARTIES_V PTY,

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
634: AND ITM.OBJECT1_ID2 = PDT.ID2

Line 649: OKX_PARTIES_V PTY,

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
653: AND ITM.OBJECT1_ID2 = PDT.Inv_Master_Organization_Id --PDT.ID2

Line 976: OKX_PARTIES_V PY

972: CURSOR l_pty_csr IS
973: SELECT IT.OBJECT1_ID1, PY.NAME
974: FROM OKC_K_LINES_B KL,
975: OKC_K_ITEMS IT,
976: OKX_PARTIES_V PY
977: WHERE KL.ID = IT.CLE_ID
978: AND IT.OBJECT1_ID1 = PY.ID1
979: AND IT.OBJECT1_ID2 = PY.ID2
980: AND IT.JTOT_OBJECT1_CODE = 'OKX_PARTY'