APPS.WMS_CONTAINER2_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1541: mtl_material_transactions_temp temp

1537: CURSOR pick_delivery_cursor IS
1538: SELECT wda.delivery_id
1539: FROM wsh_delivery_assignments wda,
1540: wsh_delivery_details wdd,
1541: mtl_material_transactions_temp temp
1542: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
1543: AND wdd.move_order_line_id = temp.move_order_line_id
1544: AND wdd.organization_id = temp.organization_id
1545: AND temp.transfer_lpn_id = p_pick_lpn_id

Line 1781: mtl_material_transactions_temp temp

1777: CURSOR pick_delivery_cursor IS
1778: SELECT wda.delivery_id
1779: FROM wsh_delivery_assignments wda,
1780: wsh_delivery_details wdd,
1781: mtl_material_transactions_temp temp
1782: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
1783: AND wdd.move_order_line_id = temp.move_order_line_id
1784: AND wdd.organization_id = temp.organization_id
1785: AND temp.transfer_lpn_id = p_pick_lpn_id

Line 2094: mtl_material_transactions_temp temp

2090: CURSOR pick_delivery_cursor IS
2091: SELECT wda.delivery_id
2092: FROM wsh_delivery_assignments wda,
2093: wsh_delivery_details wdd,
2094: mtl_material_transactions_temp temp
2095: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
2096: AND wdd.move_order_line_id = temp.move_order_line_id
2097: AND wdd.organization_id = temp.organization_id
2098: AND temp.transfer_lpn_id = p_pick_lpn_id

Line 2149: from mtl_material_transactions_temp

2145:
2146: BEGIN
2147: Select transfer_subinventory, transfer_to_location into l_drop_sub,
2148: l_drop_loc
2149: from mtl_material_transactions_temp
2150: where transfer_lpn_id = p_pick_lpn_id
2151: AND organization_id = p_organization_id;
2152:
2153: EXCEPTION