APPS.PO_VAL_DISTRIBUTIONS2 dependencies on MTL_SECONDARY_INVENTORIES

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

648:
649: -----------------------------------------------------------
650: -- Validation Logic:
651: -- If destination_type_code is INVENTORY and destination_subinventiry is not null,
652: -- validate the destination_subinventory against mtl_secondary_inventories based on
653: -- ship_to_organization_id and item_id.
654: -- If destination_type_code is SHOP FLOOR and EXPENSE, the value has to be NULL.
655: -- Need to validate that SHIKYU item can only have asset subinventory (inventory_asset = 1).
656: -----------------------------------------------------------

Line 727: FROM mtl_secondary_inventories msub

723: WHERE p_dest_type_code_tbl(i) = 'INVENTORY'
724: AND p_destination_subinv_tbl(i) IS NOT NULL
725: AND NOT EXISTS(
726: SELECT 1
727: FROM mtl_secondary_inventories msub
728: WHERE msub.organization_id = NVL(p_ship_to_org_id_tbl(i), msub.organization_id)
729: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
730: AND ( p_item_id_tbl(i) IS NULL
731: OR ( p_item_id_tbl(i) IS NOT NULL

Line 779: FROM mtl_secondary_inventories msub

775: AND p_dest_type_code_tbl(i) = 'INVENTORY'
776: AND p_loc_outsourced_assembly_tbl(i) = 1 /* SHIKYU item */
777: AND EXISTS(
778: SELECT 1
779: FROM mtl_secondary_inventories msub
780: WHERE msub.organization_id = NVL(p_ship_to_org_id_tbl(i), msub.organization_id)
781: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
782: AND msub.asset_inventory = 2 /* Not asset subinventory */
783: AND msub.secondary_inventory_name = p_destination_subinv_tbl(i));