DBA Data[Home] [Help]

APPS.POA_DBI_PO_DIST_F_C dependencies on POA_DBI_ITEMS_PKG

Line 1724: poa_dbi_items_pkg.getitemkey(pol.item_id, par.master_organization_id, pol.category_id,

1720: Trunc(nvl(pod.approved_date,pll.approved_date)) approved_date,
1721: Trunc(pod.creation_date) creation_date,
1722: poh.vendor_id,
1723: poh.vendor_site_id,
1724: poa_dbi_items_pkg.getitemkey(pol.item_id, par.master_organization_id, pol.category_id,
1725: pol.vendor_product_num, poh.vendor_id, pol.item_description) po_item_id,
1726: pol.category_id,
1727: decode(por.po_release_id, null, poh.agent_id, por.agent_id) agent_id,
1728: pod.code_combination_id, -- not used for now

Line 1992: poa_dbi_items_pkg.getitemkey(pol.item_id, par.master_organization_id, pol.category_id,

1988: may not be present. This is the true earliest approval date at distribution level */
1989: pod.creation_date creation_date,
1990: poh.vendor_id,
1991: poh.vendor_site_id,
1992: poa_dbi_items_pkg.getitemkey(pol.item_id, par.master_organization_id, pol.category_id,
1993: pol.vendor_product_num, poh.vendor_id, pol.item_description) po_item_id,
1994: pol.category_id,
1995: decode(por.po_release_id, null, poh.agent_id, por.agent_id) agent_id,
1996: pod.code_combination_id, -- not used for now