DBA Data[Home] [Help]

APPS.FLM_EXECUTION_UTIL dependencies on MTL_SERIAL_NUMBERS

Line 2032: from mtl_serial_numbers msn,

2028:
2029: FUNCTION get_single_assy_ser(p_org_id IN NUMBER, p_inv_item_id IN NUMBER) RETURN VARCHAR2 IS
2030: CURSOR assy_serials IS
2031: select serial_number
2032: from mtl_serial_numbers msn,
2033: mtl_transaction_types mtt
2034: where (msn.group_mark_id is null or msn.group_mark_id = -1)
2035: and msn.current_status in (1, 4 )
2036: and msn.inventory_item_id = p_inv_item_id