DBA Data[Home] [Help]

APPS.FLM_EXECUTION_UTIL dependencies on MTL_LOT_NUMBERS

Line 2073: from mtl_lot_numbers mln,

2069:
2070: FUNCTION get_single_assy_lot(p_org_id IN NUMBER, p_inv_item_id IN NUMBER) RETURN VARCHAR2 IS
2071: CURSOR assy_lots IS
2072: select lot_number
2073: from mtl_lot_numbers mln,
2074: mtl_transaction_types mtt
2075: where mln.inventory_item_id = p_inv_item_id
2076: and mln.organization_id = p_org_id
2077: and mtt.transaction_type_id = 44