APPS.PO_VAL_DISTRIBUTIONS2 dependencies on MTL_SECONDARY_INVENTORIES

Line 640: -- validate the destination_subinventory against mtl_secondary_inventories based on

636:
637: -----------------------------------------------------------
638: -- Validation Logic:
639: -- If destination_type_code is INVENTORY and destination_subinventiry is not null,
640: -- validate the destination_subinventory against mtl_secondary_inventories based on
641: -- ship_to_organization_id and item_id.
642: -- If destination_type_code is SHOP FLOOR and EXPENSE, the value has to be NULL.
643: -- Need to validate that SHIKYU item can only have asset subinventory (inventory_asset = 1).
644: -----------------------------------------------------------

Line 715: FROM mtl_secondary_inventories msub

711: WHERE p_dest_type_code_tbl(i) = 'INVENTORY'
712: AND p_destination_subinv_tbl(i) IS NOT NULL
713: AND NOT EXISTS(
714: SELECT 1
715: FROM mtl_secondary_inventories msub
716: WHERE msub.organization_id = NVL(p_ship_to_org_id_tbl(i), msub.organization_id)
717: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
718: AND ( p_item_id_tbl(i) IS NULL
719: OR ( p_item_id_tbl(i) IS NOT NULL

Line 767: FROM mtl_secondary_inventories msub

763: AND p_dest_type_code_tbl(i) = 'INVENTORY'
764: AND p_loc_outsourced_assembly_tbl(i) = 1 /* SHIKYU item */
765: AND EXISTS(
766: SELECT 1
767: FROM mtl_secondary_inventories msub
768: WHERE msub.organization_id = NVL(p_ship_to_org_id_tbl(i), msub.organization_id)
769: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
770: AND msub.asset_inventory = 2 /* Not asset subinventory */
771: AND msub.secondary_inventory_name = p_destination_subinv_tbl(i));