DBA Data[Home] [Help]

APPS.FLM_EXECUTION_UTIL dependencies on MTL_TRANSACTION_TYPES

Line 1813: mtl_transaction_types mtt

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
1817: and msn.current_organization_id = p_org_id

Line 1854: mtl_transaction_types mtt

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
1858: and inv_material_status_grp.is_status_applicable(