DBA Data[Home] [Help]

APPS.INV_ITEM_INQ dependencies on INV_MATERIAL_STATUS_GRP

Line 1637: (INV_MATERIAL_STATUS_GRP.is_status_applicable(

1633: )
1634: and serial_number like (p_serial_number)
1635: AND (group_mark_id is null OR group_mark_id = -1) -- Bug # 2591673
1636: and
1637: (INV_MATERIAL_STATUS_GRP.is_status_applicable(
1638: 'TRUE',
1639: NULL,
1640: p_transactiontypeid,
1641: NULL,

Line 1672: AND inv_material_status_grp.is_status_applicable

1668: and inventory_item_id = p_inventory_item_id
1669: --and current_status in (3, 5)
1670: AND current_status in (3, 5, 7)
1671: and serial_number like p_serial_number
1672: AND inv_material_status_grp.is_status_applicable
1673: (p_wms_installed,
1674: NULL,
1675: p_txn_type_id,
1676: NULL,