DBA Data[Home] [Help]

APPS.OKS_ENT_UTIL_PVT dependencies on OKX_PARTY_SITES_V

Line 631: OKX_PARTY_SITES_V SIT --OKX_PARTY_SITE_USES_V SIT

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
635: AND PDT.CUSTOMER_ID = CUS.ID1

Line 650: OKX_PARTY_SITES_V SIT --OKX_PARTY_SITE_USES_V

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
654: and PDT.owner_party_account_id = CUS.ID1 -- AND PDT.CUSTOMER_ID = CUS.ID1