APPS.GML_MOBILE_RECEIPT dependencies on INV_MATERIAL_STATUS_GRP

Line 3141: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL,

3137: FROM mtl_secondary_inventories msub
3138: WHERE msub.organization_id = p_organization_id
3139: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3140: AND msub.secondary_inventory_name LIKE (p_sub)
3141: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL,
3142: p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id,
3143: msub.secondary_inventory_name, NULL, NULL, NULL, 'Z') = 'Y'
3144: ORDER BY UPPER(msub.secondary_inventory_name);
3145: ELSE

Line 3164: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL,

3160: mis.organization_id)
3161:
3162: AND mis.inventory_item_id = p_item_id
3163: AND mis.secondary_inventory = msub.secondary_inventory_name)
3164: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL,
3165: p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id,
3166: msub.secondary_inventory_name, NULL, NULL, NULL, 'Z') = 'Y'
3167: ORDER BY UPPER(msub.secondary_inventory_name);
3168: END IF;

Line 3489: AND inv_material_status_grp.is_status_applicable

3485: AND a.inventory_location_id = b.secondary_locator
3486: AND a.concatenated_segments LIKE (p_concatenated_segments||'%')
3487: /* BUG#2810405: To show only common locators in the LOV */
3488: /*
3489: AND inv_material_status_grp.is_status_applicable
3490: ( p_wms_installed,
3491: NULL,
3492: p_transaction_type_id,
3493: NULL,

Line 3519: AND inv_material_status_grp.is_status_applicable

3515: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
3516: AND concatenated_segments LIKE (p_concatenated_segments||'%' )
3517: /* BUG#2810405: To show only common locators in the LOV */
3518: /*
3519: AND inv_material_status_grp.is_status_applicable
3520: ( p_wms_installed,
3521: NULL,
3522: p_transaction_type_id,
3523: NULL,

Line 3551: AND inv_material_status_grp.is_status_applicable

3547: AND b.subinventory_code = p_Subinventory_Code
3548: AND a.inventory_location_id = b.secondary_locator
3549: /* BUG#2810405: To show only common locators in the LOV */
3550: /*
3551: AND inv_material_status_grp.is_status_applicable
3552: ( p_wms_installed,
3553: NULL,
3554: p_transaction_type_id,
3555: NULL,

Line 3579: AND inv_material_status_grp.is_status_applicable

3575: AND a.inventory_location_id = l.inventory_location_id
3576: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
3577: /* BUG#2810405: To show only common locators in the LOV */
3578: /*
3579: AND inv_material_status_grp.is_status_applicable
3580: ( p_wms_installed,
3581: NULL,
3582: p_transaction_type_id,
3583: NULL,