APPS.PO_VALIDATION_HELPER dependencies on MTL_SYSTEM_ITEMS

Line 2629: FROM mtl_system_items msi

2625: -- SQL What : Get the sec indicator
2626: -- SQL Why : To check if we need to do opm validations
2627: SELECT decode(msi.tracking_quantity_ind,'PS',msi.secondary_default_ind,NULL)
2628: INTO l_sec_default_ind
2629: FROM mtl_system_items msi
2630: WHERE msi.organization_id = p_inv_org_id_tbl(i)
2631: AND msi.inventory_item_id = p_item_id_tbl(i);
2632: Exception
2633: When no_data_found then

Line 2772: FROM mtl_system_items msi

2768: -- SQL What : Get the sec indicator
2769: -- SQL Why : To check if we need to do opm validations
2770: SELECT decode(msi.tracking_quantity_ind,'PS',msi.secondary_default_ind,NULL)
2771: INTO l_sec_default_ind
2772: FROM mtl_system_items msi
2773: WHERE msi.organization_id = p_inv_org_id_tbl(i)
2774: AND msi.inventory_item_id = p_item_id_tbl(i);
2775: Exception
2776: When no_data_found then

Line 3230: FROM mtl_system_items msi

3226: AND p_organization_id_tbl(i) IS NOT NULL
3227: AND p_secondary_unit_of_meas_tbl(i) IS NOT NULL
3228: AND EXISTS(
3229: SELECT 1
3230: FROM mtl_system_items msi
3231: WHERE msi.inventory_item_id = p_item_id_tbl(i)
3232: AND msi.organization_id = p_organization_id_tbl(i)
3233: AND p_secondary_unit_of_meas_tbl(i) <> msi.secondary_uom_code);
3234:

Line 3345: FROM mtl_system_items msi

3341: WHERE p_preferred_grade_tbl(i) IS NOT NULL
3342: AND p_item_id_tbl(i) IS NOT NULL
3343: AND EXISTS(
3344: SELECT 1
3345: FROM mtl_system_items msi
3346: WHERE msi.inventory_item_id = p_item_id_tbl(i)
3347: AND msi.organization_id = p_organization_id_tbl(i)
3348: AND nvl(msi.grade_control_flag,'N') = 'N');
3349:

Line 3449: FROM mtl_system_items msi,

3445: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
3446: AND p_item_id_tbl(i) IS NOT NULL
3447: AND EXISTS(
3448: SELECT 1
3449: FROM mtl_system_items msi,
3450: mtl_parameters mp
3451: WHERE msi.inventory_item_id = p_item_id_tbl(i)
3452: AND msi.organization_id = p_ship_to_organization_id_tbl(i)
3453: AND msi.organization_id = mp.organization_id

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

3473:
3474: END process_enabled;
3475:
3476: --------------------------------------------------------------------------------------------
3477: -- Private function to get the converted unit of measure from mtl_system_items.
3478: --------------------------------------------------------------------------------------------
3479: FUNCTION get_item_secondary_uom(
3480: p_item_id_tbl IN po_tbl_number,
3481: p_organization_id_tbl IN po_tbl_number)

Line 3512: FROM mtl_system_items msi,

3508:
3509: FORALL i IN 1..p_item_id_tbl.COUNT
3510: INSERT INTO po_session_gt(key, num1, char1)
3511: SELECT l_key, l_index_tbl(i), uom.unit_of_measure
3512: FROM mtl_system_items msi,
3513: mtl_units_of_measure uom
3514: WHERE msi.inventory_item_id = p_item_id_tbl(i)
3515: AND msi.organization_id = p_organization_id_tbl(i)
3516: AND msi.tracking_quantity_ind = 'PS'