APPS.PO_INV_THIRD_PARTY_STOCK_MDTR dependencies on PO_ASL_ATTRIBUTES

Line 175: FROM po_asl_attributes

171: -- Do not hardcode schema names
172: -- GSCC checker parses asl as schema name even though in this case
173: -- it is just an alias. Changing the alias name from asl to po_asl.
174: FOR po_asl IN (SELECT item_id, vendor_site_id
175: FROM po_asl_attributes
176: WHERE vendor_id = p_vendor_id
177: AND vendor_site_id IS NOT NULL
178: AND consigned_from_supplier_flag IS NOT NULL
179: ORDER BY consigned_from_supplier_flag DESC)

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

225: FUNCTION Sup_Site_Owns_Tps(p_vendor_site_id IN Number) RETURN BOOLEAN IS
226:
227: l_onhand_qty mtl_onhand_quantities_detail.primary_transaction_quantity%TYPE;
228:
229: TYPE item_id_tbl_type IS TABLE OF po_asl_attributes_val_v.item_id%TYPE
230: INDEX BY BINARY_INTEGER;
231:
232: item_id_tbl item_id_tbl_type;
233:

Line 240: FROM po_asl_attributes

236: IF p_vendor_site_id IS NOT NULL
237: THEN
238:
239: SELECT item_id BULK COLLECT INTO item_id_tbl
240: FROM po_asl_attributes
241: WHERE vendor_site_id = p_vendor_site_id
242: AND consigned_from_supplier_flag IS NOT NULL
243: ORDER BY consigned_from_supplier_flag DESC;
244: