DBA Data[Home] [Help]

APPS.EDW_SUPPLIER_ITEM_PKG dependencies on EDW_POA_SPIM_SPLRITEM_FKV

Line 9: -- Underlining View: EDW_POA_SPIM_SPLRITEM_FKV

5: -- Supplier Item API for SUPPLIER_ITEM DIMENSION
6: --
7: -- Function returns Supplier_Item level foreign key
8: --
9: -- Underlining View: EDW_POA_SPIM_SPLRITEM_FKV
10: -- ---------------------------------------------------------
11:
12: -- Use Supplier Site ID as a parameter
13: --

Line 23: from EDW_POA_SPIM_SPLRITEM_FKV

19: l_fk VARCHAR2(240) := 'NA_EDW';
20:
21: cursor supplier_item_num_cur is
22: select supplier_item_pk
23: from EDW_POA_SPIM_SPLRITEM_FKV
24: where vendor_name = p_supplier_name
25: and vendor_site_id = p_supplier_site_id
26: and vendor_product_num = p_supplier_product_num;
27: BEGIN

Line 56: from EDW_POA_SPIM_SPLRITEM_FKV

52: l_fk VARCHAR2(240) := 'NA_EDW';
53:
54: cursor supplier_item_num_cur is
55: select supplier_item_pk
56: from EDW_POA_SPIM_SPLRITEM_FKV
57: where vendor_name = p_supplier_name
58: and vendor_site_code = p_supplier_site_code
59: and vendor_product_num = p_supplier_product_num;
60: BEGIN