DBA Data[Home] [Help]

APPS.GME_MOBILE_LOVS dependencies on INV_MATERIAL_STATUS_GRP

Line 3096: AND (inv_material_status_grp.is_status_applicable(

3092: AND mln.inventory_item_id = p_item_id
3093: AND mln.lot_number LIKE (p_lot_number)
3094: AND NVL(mln.expiration_date,SYSDATE+1) > SYSDATE --Bug#5092198
3095: /*Bug#8937132 including the check for the lot status allows the transaction or not*/
3096: AND (inv_material_status_grp.is_status_applicable(
3097: NULL
3098: ,NULL
3099: ,p_transaction_type
3100: ,NULL

Line 3127: AND (inv_material_status_grp.is_status_applicable(

3123: WHERE mln.organization_id = p_organization_id
3124: AND mln.inventory_item_id = p_item_id
3125: AND mln.lot_number LIKE (p_lot_number)
3126: AND NVL(mln.expiration_date,SYSDATE+1) > SYSDATE --Bug#5092198
3127: AND (inv_material_status_grp.is_status_applicable(
3128: NULL
3129: ,NULL
3130: ,p_transaction_type
3131: ,NULL

Line 3158: AND (inv_material_status_grp.is_status_applicable(

3154: -- Bug 12562057 - Remove explicit parameter names as it does not compile on versions below 11g.
3155:
3156:
3157: /*
3158: AND (inv_material_status_grp.is_status_applicable(
3159: p_wms_installed => NULL
3160: ,p_trx_status_enabled => NULL
3161: ,p_trx_type_id => p_transaction_type
3162: ,p_lot_status_enabled => NULL