APPS.WMS_OP_INBOUND_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 518: FROM mtl_secondary_inventories

514: AND organization_id=v_org_id;
515: */
516: CURSOR c_sub_type(v_sub_code VARCHAR2,v_org_id NUMBER) IS
517: SELECT Nvl(subinventory_type, 1)
518: FROM mtl_secondary_inventories
519: WHERE secondary_inventory_name=v_sub_code
520: AND organization_id=v_org_id;
521:
522: CURSOR c_orig_sugges(v_txn_temp_id NUMBER) IS

Line 1068: mtl_secondary_inventories msi,

1064: mol.backorder_delivery_detail_id,
1065: mmtt.transfer_to_location,
1066: mmtt.locator_id
1067: FROM mtl_material_transactions_temp mmtt,
1068: mtl_secondary_inventories msi,
1069: mtl_txn_request_lines mol
1070: WHERE mmtt.transaction_temp_id = p_source_task_id
1071: AND Nvl(mmtt.transfer_subinventory, mmtt.subinventory_code) = msi.secondary_inventory_name (+)
1072: AND mmtt.organization_id = msi.organization_id (+)

Line 1085: FROM mtl_secondary_inventories

1081: */
1082:
1083: CURSOR c_subinventory_type(v_subinventory_code VARCHAR2, v_org_id NUMBER) IS
1084: SELECT subinventory_type
1085: FROM mtl_secondary_inventories
1086: WHERE secondary_inventory_name = v_subinventory_code
1087: AND organization_id = v_org_id;
1088:
1089: l_mmtt_data_rec c_mmtt_data_rec%ROWTYPE;

Line 1552: FROM mtl_secondary_inventories

1548: IF p_document_rec.transfer_subinventory IS NOT NULL THEN
1549:
1550: SELECT subinventory_type
1551: INTO l_dest_subinventory_type
1552: FROM mtl_secondary_inventories
1553: WHERE secondary_inventory_name = p_document_rec.transfer_subinventory
1554: AND organization_id = p_document_rec.organization_id;
1555: ELSE
1556:

Line 1559: FROM mtl_secondary_inventories

1555: ELSE
1556:
1557: SELECT subinventory_type
1558: INTO l_dest_subinventory_type
1559: FROM mtl_secondary_inventories
1560: WHERE secondary_inventory_name = p_document_rec.subinventory_code
1561: AND organization_id = p_document_rec.organization_id;
1562:
1563: END IF; -- IF p_document_rec.transfer_subinventory IS NOT NULL

Line 1825: FROM mtl_secondary_inventories

1821: IF p_document_rec.transfer_subinventory IS NOT NULL THEN
1822:
1823: SELECT subinventory_type
1824: INTO l_dest_subinventory_type
1825: FROM mtl_secondary_inventories
1826: WHERE secondary_inventory_name = p_document_rec.transfer_subinventory
1827: AND organization_id = p_document_rec.organization_id;
1828: ELSE
1829:

Line 1832: FROM mtl_secondary_inventories

1828: ELSE
1829:
1830: SELECT subinventory_type
1831: INTO l_dest_subinventory_type
1832: FROM mtl_secondary_inventories
1833: WHERE secondary_inventory_name = p_document_rec.subinventory_code
1834: AND organization_id = p_document_rec.organization_id;
1835:
1836: END IF; -- IF p_document_rec.transfer_subinventory IS NOT NULL