DBA Data[Home] [Help]

APPS.FLM_EXECUTION_UTIL dependencies on MTL_SERIAL_NUMBERS

Line 1812: from mtl_serial_numbers msn,

1808:
1809: FUNCTION get_single_assy_ser(p_org_id IN NUMBER, p_inv_item_id IN NUMBER) RETURN VARCHAR2 IS
1810: CURSOR assy_serials IS
1811: select serial_number
1812: from mtl_serial_numbers msn,
1813: mtl_transaction_types mtt
1814: where (msn.group_mark_id is null or msn.group_mark_id = -1)
1815: and msn.current_status in (1, 4 )
1816: and msn.inventory_item_id = p_inv_item_id