APPS.PO_VALIDATION_HELPER dependencies on MTL_SYSTEM_ITEMS

Line 2444: FROM mtl_system_items msi

2440: -- SQL What : Get the sec indicator
2441: -- SQL Why : To check if we need to do opm validations
2442: SELECT decode(msi.tracking_quantity_ind,'PS',msi.secondary_default_ind,NULL)
2443: INTO l_sec_default_ind
2444: FROM mtl_system_items msi
2445: WHERE msi.organization_id = p_inv_org_id_tbl(i)
2446: AND msi.inventory_item_id = p_item_id_tbl(i);
2447: Exception
2448: When no_data_found then

Line 2587: FROM mtl_system_items msi

2583: -- SQL What : Get the sec indicator
2584: -- SQL Why : To check if we need to do opm validations
2585: SELECT decode(msi.tracking_quantity_ind,'PS',msi.secondary_default_ind,NULL)
2586: INTO l_sec_default_ind
2587: FROM mtl_system_items msi
2588: WHERE msi.organization_id = p_inv_org_id_tbl(i)
2589: AND msi.inventory_item_id = p_item_id_tbl(i);
2590: Exception
2591: When no_data_found then

Line 3043: FROM mtl_system_items msi

3039: AND p_organization_id_tbl(i) IS NOT NULL
3040: AND p_secondary_unit_of_meas_tbl(i) IS NOT NULL
3041: AND EXISTS(
3042: SELECT 1
3043: FROM mtl_system_items msi
3044: WHERE msi.inventory_item_id = p_item_id_tbl(i)
3045: AND msi.organization_id = p_organization_id_tbl(i)
3046: AND p_secondary_unit_of_meas_tbl(i) <> msi.secondary_uom_code);
3047:

Line 3158: FROM mtl_system_items msi

3154: WHERE p_preferred_grade_tbl(i) IS NOT NULL
3155: AND p_item_id_tbl(i) IS NOT NULL
3156: AND EXISTS(
3157: SELECT 1
3158: FROM mtl_system_items msi
3159: WHERE msi.inventory_item_id = p_item_id_tbl(i)
3160: AND msi.organization_id = p_organization_id_tbl(i)
3161: AND nvl(msi.grade_control_flag,'N') = 'N');
3162:

Line 3262: FROM mtl_system_items msi,

3258: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
3259: AND p_item_id_tbl(i) IS NOT NULL
3260: AND EXISTS(
3261: SELECT 1
3262: FROM mtl_system_items msi,
3263: mtl_parameters mp
3264: WHERE msi.inventory_item_id = p_item_id_tbl(i)
3265: AND msi.organization_id = p_ship_to_organization_id_tbl(i)
3266: AND msi.organization_id = mp.organization_id

Line 3290: -- Private function to get the converted unit of measure from mtl_system_items.

3286:
3287: END process_enabled;
3288:
3289: --------------------------------------------------------------------------------------------
3290: -- Private function to get the converted unit of measure from mtl_system_items.
3291: --------------------------------------------------------------------------------------------
3292: FUNCTION get_item_secondary_uom(
3293: p_item_id_tbl IN po_tbl_number,
3294: p_organization_id_tbl IN po_tbl_number)

Line 3325: FROM mtl_system_items msi,

3321:
3322: FORALL i IN 1..p_item_id_tbl.COUNT
3323: INSERT INTO po_session_gt(key, num1, char1)
3324: SELECT l_key, l_index_tbl(i), uom.unit_of_measure
3325: FROM mtl_system_items msi,
3326: mtl_units_of_measure uom
3327: WHERE msi.inventory_item_id = p_item_id_tbl(i)
3328: AND msi.organization_id = p_organization_id_tbl(i)
3329: AND msi.tracking_quantity_ind = 'PS'