APPS.PO_INV_THIRD_PARTY_STOCK_MDTR dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 121: -- use of index on MTL_ONHAND_QUANTITIES_DETAIL.

117: -- CHANGE HISTORY :
118: -- 18-Nov-2002 Created by VMA
119: -- 30-Oct-2003 Bug fix for bug #3131113:
120: -- 1. Added query to PO_APPROVED_SUPPLIER_LIST to make
121: -- use of index on MTL_ONHAND_QUANTITIES_DETAIL.
122: -- 2. Updated logic to check for existance of onhand
123: -- consigned stock. Old logic checked existence of
124: -- any record in MOQD. This is replaced with new logic
125: -- that checks the sum of primary_transaction_quantity

Line 130: l_onhand_qty mtl_onhand_quantities_detail.primary_transaction_quantity%TYPE;

126: -- for an item owned by a supplier in MOQD.
127: --========================================================================
128: FUNCTION Supplier_Owns_Tps (p_vendor_id IN NUMBER) RETURN BOOLEAN IS
129:
130: l_onhand_qty mtl_onhand_quantities_detail.primary_transaction_quantity%TYPE;
131:
132: BEGIN
133:
134: IF p_vendor_id IS NOT NULL

Line 149: FROM mtl_onhand_quantities_detail

145: ORDER BY consigned_from_supplier_flag DESC)
146: LOOP
147: SELECT SUM(primary_transaction_quantity)
148: INTO l_onhand_qty
149: FROM mtl_onhand_quantities_detail
150: WHERE inventory_item_id = po_asl.item_id
151: AND owning_organization_id = po_asl.vendor_site_id
152: AND owning_tp_type = 1;
153:

Line 184: -- index on MTL_ONHAND_QUANTITIES_DETAIL.

180: -- CHANGE HISTORY :
181: -- 18-Nov-2002 Created by VMA
182: -- 30-Oct-2003 Bug fix for bug #3131113:
183: -- 1. Added query PO_APPROVED_SUPPLIER_LIST to use
184: -- index on MTL_ONHAND_QUANTITIES_DETAIL.
185: -- 2. Updated logic to check for existance of onhand
186: -- consigned stock. Old logic checked existence of
187: -- any record in MOQD. This is replaced with new logic
188: -- that checks the sum of primary_transaction_quantity

Line 193: l_onhand_qty mtl_onhand_quantities_detail.primary_transaction_quantity%TYPE;

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

Line 215: FROM mtl_onhand_quantities_detail

211: FOR i IN item_id_tbl.FIRST..item_id_tbl.LAST
212: LOOP
213: SELECT SUM(primary_transaction_quantity)
214: INTO l_onhand_qty
215: FROM mtl_onhand_quantities_detail
216: WHERE inventory_item_id = item_id_tbl(i)
217: AND ((owning_organization_id = p_vendor_site_id
218: AND owning_tp_type = 1)
219: OR (planning_organization_id = p_vendor_site_id