APPS.WSH_OPSM_ASN_ITEM_GENEALOGY dependencies on WSH_NEW_DELIVERIES

Line 2143: wsh_new_deliveries wnd

2139: SELECT wnd.delivery_id
2140: INTO v_delivery_id
2141: FROM mtl_transaction_details_v mtd ,
2142: mtl_material_transactions mmt ,
2143: wsh_new_deliveries wnd
2144: WHERE mtd.object_id = v_top(i).object_id
2145: AND mmt.transaction_id = mtd.transaction_id + 0
2146: AND wnd.delivery_id = mmt.trx_source_delivery_id + 0;
2147: IF l_debug_on THEN

Line 2166: wsh_new_deliveries wnd

2162: SELECT wnd.delivery_id
2163: INTO v_delivery_id1
2164: FROM mtl_transaction_details_v mtd ,
2165: mtl_material_transactions mmt ,
2166: wsh_new_deliveries wnd
2167: WHERE mtd.object_id = v_top(i).object_id
2168: AND mmt.transaction_id = mtd.transaction_id + 0
2169: AND wnd.delivery_id = mmt.trx_source_delivery_id + 0;
2170: IF l_debug_on THEN

Line 4369: wsh_new_deliveries wnd

4365: SELECT wnd.delivery_id
4366: INTO v_delivery_id
4367: FROM mtl_transaction_details_v mtd ,
4368: mtl_material_transactions mmt ,
4369: wsh_new_deliveries wnd
4370: WHERE mtd.object_id = v_top(i).object_id
4371: AND mmt.transaction_id = mtd.transaction_id + 0
4372: AND wnd.delivery_id = mmt.trx_source_delivery_id + 0;
4373: IF l_debug_on THEN

Line 4392: wsh_new_deliveries wnd

4388: SELECT wnd.delivery_id
4389: INTO v_delivery_id1
4390: FROM mtl_transaction_details_v mtd ,
4391: mtl_material_transactions mmt ,
4392: wsh_new_deliveries wnd
4393: WHERE mtd.object_id = v_top(i).object_id
4394: AND mmt.transaction_id = mtd.transaction_id + 0
4395: AND wnd.delivery_id = mmt.trx_source_delivery_id + 0;
4396: IF l_debug_on THEN