DBA Data[Home] [Help]

APPS.MTL_INV_UTIL_GRP dependencies on INV_CYC_LOVS

Line 1318: AND INV_CYC_LOVS.is_serial_loaded(p_organization_id,p_inventory_item_id,p_serial_number,p_lpn_id) = 2;

1314: AND serial_number = p_serial_number
1315: AND NVL(lot_number, '@') = NVL(p_lot_number, '@')
1316: AND NVL(revision, '@') = NVL(p_revision, '@')
1317: AND NVL(cost_group_id, -1) = NVL(p_cost_group_id, -1)
1318: AND INV_CYC_LOVS.is_serial_loaded(p_organization_id,p_inventory_item_id,p_serial_number,p_lpn_id) = 2;
1319: END IF;
1320:
1321: IF (x_lpn_systemqty IS NULL) THEN
1322: x_lpn_systemqty := 0;

Line 1505: AND inv_cyc_lovs.is_serial_loaded (p_organization_id

1501: AND serial_number = p_serial_number
1502: AND NVL (lot_number, '@') = NVL (p_lot_number, '@')
1503: AND NVL (revision, '@') = NVL (p_revision, '@')
1504: AND NVL (cost_group_id, -1) = NVL (p_cost_group_id, -1)
1505: AND inv_cyc_lovs.is_serial_loaded (p_organization_id
1506: , p_inventory_item_id
1507: , p_serial_number
1508: , p_lpn_id
1509: ) = 2;