DBA Data[Home] [Help]

APPS.WMA_SPECIAL_LOVS dependencies on INV_MATERIAL_STATUS_GRP

Line 32: and inv_material_status_grp.is_status_applicable(

28: from mtl_secondary_inventories
29: where organization_id = orgID
30: and secondary_inventory_name like invName || '%'
31: and secondary_inventory_name <> 'AX_INTRANS'
32: and inv_material_status_grp.is_status_applicable(
33: NULL, -- p_wms_installed,
34: NULL,
35: trxTypeID, -- p_trx_type_id (is this same as trx_type_id?)
36: NULL,

Line 59: and inv_material_status_grp.is_status_applicable(

55: and misi.inventory_item_id = itemID
56: and misi.organization_id = orgID
57: and misi.secondary_inventory like invName || '%'
58: and misi.secondary_inventory <> 'AX_INTRANS'
59: and inv_material_status_grp.is_status_applicable(
60: NULL, -- p_wms_installed,
61: NULL,
62: trxTypeID, -- p_trx_type_id (is this same as trx_type_id?)
63: NULL,

Line 157: and inv_material_status_grp.is_status_applicable(

153: from mtl_item_locations_kfv
154: where organization_id = orgID
155: and subinventory_code = subinv
156: and concatenated_segments like locName || '%'
157: and inv_material_status_grp.is_status_applicable(
158: NULL, -- p_wms_installed,
159: NULL,
160: trxTypeID, -- p_trx_type_id (is this same as trx_type_id?)
161: NULL,

Line 185: and inv_material_status_grp.is_status_applicable(

181: and msl.inventory_item_id = itemID
182: and msl.organization_id = orgID
183: and msl.subinventory_code = subinv
184: and milk.concatenated_segments like locName || '%'
185: and inv_material_status_grp.is_status_applicable(
186: NULL, -- p_wms_installed,
187: NULL,
188: trxTypeID, -- p_trx_type_id (is this same as trx_type_id?)
189: NULL,