APPS.PO_INV_THIRD_PARTY_STOCK_MDTR dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 155: -- use of index on MTL_ONHAND_QUANTITIES_DETAIL.

151: -- CHANGE HISTORY :
152: -- 18-Nov-2002 Created by VMA
153: -- 30-Oct-2003 Bug fix for bug #3131113:
154: -- 1. Added query to PO_APPROVED_SUPPLIER_LIST to make
155: -- use of index on MTL_ONHAND_QUANTITIES_DETAIL.
156: -- 2. Updated logic to check for existance of onhand
157: -- consigned stock. Old logic checked existence of
158: -- any record in MOQD. This is replaced with new logic
159: -- that checks the sum of primary_transaction_quantity

Line 164: l_onhand_qty mtl_onhand_quantities_detail.primary_transaction_quantity%TYPE;

160: -- for an item owned by a supplier in MOQD.
161: --========================================================================
162: FUNCTION Supplier_Owns_Tps (p_vendor_id IN NUMBER) RETURN BOOLEAN IS
163:
164: l_onhand_qty mtl_onhand_quantities_detail.primary_transaction_quantity%TYPE;
165:
166: BEGIN
167:
168: IF p_vendor_id IS NOT NULL

Line 183: FROM mtl_onhand_quantities_detail

179: ORDER BY consigned_from_supplier_flag DESC)
180: LOOP
181: SELECT SUM(primary_transaction_quantity)
182: INTO l_onhand_qty
183: FROM mtl_onhand_quantities_detail
184: WHERE inventory_item_id = po_asl.item_id
185: AND owning_organization_id = po_asl.vendor_site_id
186: AND owning_tp_type = 1;
187:

Line 218: -- index on MTL_ONHAND_QUANTITIES_DETAIL.

214: -- CHANGE HISTORY :
215: -- 18-Nov-2002 Created by VMA
216: -- 30-Oct-2003 Bug fix for bug #3131113:
217: -- 1. Added query PO_APPROVED_SUPPLIER_LIST to use
218: -- index on MTL_ONHAND_QUANTITIES_DETAIL.
219: -- 2. Updated logic to check for existance of onhand
220: -- consigned stock. Old logic checked existence of
221: -- any record in MOQD. This is replaced with new logic
222: -- that checks the sum of primary_transaction_quantity

Line 227: l_onhand_qty mtl_onhand_quantities_detail.primary_transaction_quantity%TYPE;

223: -- for an item owned by a supplier site in MOQD.
224: --========================================================================
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:

Line 249: FROM mtl_onhand_quantities_detail

245: FOR i IN item_id_tbl.FIRST..item_id_tbl.LAST
246: LOOP
247: SELECT SUM(primary_transaction_quantity)
248: INTO l_onhand_qty
249: FROM mtl_onhand_quantities_detail
250: WHERE inventory_item_id = item_id_tbl(i)
251: AND ((owning_organization_id = p_vendor_site_id
252: AND owning_tp_type = 1)
253: OR (planning_organization_id = p_vendor_site_id