APPS.PO_INV_THIRD_PARTY_STOCK_MDTR dependencies on PO_ASL_ATTRIBUTES

Line 141: FROM po_asl_attributes

137: -- Do not hardcode schema names
138: -- GSCC checker parses asl as schema name even though in this case
139: -- it is just an alias. Changing the alias name from asl to po_asl.
140: FOR po_asl IN (SELECT item_id, vendor_site_id
141: FROM po_asl_attributes
142: WHERE vendor_id = p_vendor_id
143: AND vendor_site_id IS NOT NULL
144: AND consigned_from_supplier_flag IS NOT NULL
145: ORDER BY consigned_from_supplier_flag DESC)

Line 195: TYPE item_id_tbl_type IS TABLE OF po_asl_attributes_val_v.item_id%TYPE

191: FUNCTION Sup_Site_Owns_Tps(p_vendor_site_id IN Number) RETURN BOOLEAN IS
192:
193: l_onhand_qty mtl_onhand_quantities_detail.primary_transaction_quantity%TYPE;
194:
195: TYPE item_id_tbl_type IS TABLE OF po_asl_attributes_val_v.item_id%TYPE
196: INDEX BY BINARY_INTEGER;
197:
198: item_id_tbl item_id_tbl_type;
199:

Line 206: FROM po_asl_attributes

202: IF p_vendor_site_id IS NOT NULL
203: THEN
204:
205: SELECT item_id BULK COLLECT INTO item_id_tbl
206: FROM po_asl_attributes
207: WHERE vendor_site_id = p_vendor_site_id
208: AND consigned_from_supplier_flag IS NOT NULL
209: ORDER BY consigned_from_supplier_flag DESC;
210: