APPS.WMS_OP_INBOUND_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 508: FROM mtl_secondary_inventories

504: AND organization_id=v_org_id;
505: */
506: CURSOR c_sub_type(v_sub_code VARCHAR2,v_org_id NUMBER) IS
507: SELECT Nvl(subinventory_type, 1)
508: FROM mtl_secondary_inventories
509: WHERE secondary_inventory_name=v_sub_code
510: AND organization_id=v_org_id;
511:
512: CURSOR c_orig_sugges(v_txn_temp_id NUMBER) IS

Line 1029: mtl_secondary_inventories msi,

1025: mol.backorder_delivery_detail_id,
1026: mmtt.transfer_to_location,
1027: mmtt.locator_id
1028: FROM mtl_material_transactions_temp mmtt,
1029: mtl_secondary_inventories msi,
1030: mtl_txn_request_lines mol
1031: WHERE mmtt.transaction_temp_id = p_source_task_id
1032: AND Nvl(mmtt.transfer_subinventory, mmtt.subinventory_code) = msi.secondary_inventory_name (+)
1033: AND mmtt.organization_id = msi.organization_id (+)

Line 1046: FROM mtl_secondary_inventories

1042: */
1043:
1044: CURSOR c_subinventory_type(v_subinventory_code VARCHAR2, v_org_id NUMBER) IS
1045: SELECT subinventory_type
1046: FROM mtl_secondary_inventories
1047: WHERE secondary_inventory_name = v_subinventory_code
1048: AND organization_id = v_org_id;
1049:
1050: l_mmtt_data_rec c_mmtt_data_rec%ROWTYPE;

Line 1513: FROM mtl_secondary_inventories

1509: IF p_document_rec.transfer_subinventory IS NOT NULL THEN
1510:
1511: SELECT subinventory_type
1512: INTO l_dest_subinventory_type
1513: FROM mtl_secondary_inventories
1514: WHERE secondary_inventory_name = p_document_rec.transfer_subinventory
1515: AND organization_id = p_document_rec.organization_id;
1516: ELSE
1517:

Line 1520: FROM mtl_secondary_inventories

1516: ELSE
1517:
1518: SELECT subinventory_type
1519: INTO l_dest_subinventory_type
1520: FROM mtl_secondary_inventories
1521: WHERE secondary_inventory_name = p_document_rec.subinventory_code
1522: AND organization_id = p_document_rec.organization_id;
1523:
1524: END IF; -- IF p_document_rec.transfer_subinventory IS NOT NULL

Line 1781: FROM mtl_secondary_inventories

1777: IF p_document_rec.transfer_subinventory IS NOT NULL THEN
1778:
1779: SELECT subinventory_type
1780: INTO l_dest_subinventory_type
1781: FROM mtl_secondary_inventories
1782: WHERE secondary_inventory_name = p_document_rec.transfer_subinventory
1783: AND organization_id = p_document_rec.organization_id;
1784: ELSE
1785:

Line 1788: FROM mtl_secondary_inventories

1784: ELSE
1785:
1786: SELECT subinventory_type
1787: INTO l_dest_subinventory_type
1788: FROM mtl_secondary_inventories
1789: WHERE secondary_inventory_name = p_document_rec.subinventory_code
1790: AND organization_id = p_document_rec.organization_id;
1791:
1792: END IF; -- IF p_document_rec.transfer_subinventory IS NOT NULL