DBA Data[Home] [Help]

APPS.FLM_EXECUTION_UTIL dependencies on MTL_LOT_NUMBERS

Line 1853: from mtl_lot_numbers mln,

1849:
1850: FUNCTION get_single_assy_lot(p_org_id IN NUMBER, p_inv_item_id IN NUMBER) RETURN VARCHAR2 IS
1851: CURSOR assy_lots IS
1852: select lot_number
1853: from mtl_lot_numbers mln,
1854: mtl_transaction_types mtt
1855: where mln.inventory_item_id = p_inv_item_id
1856: and mln.organization_id = p_org_id
1857: and mtt.transaction_type_id = 44