DBA Data[Home] [Help]

APPS.FLM_EXECUTION_UTIL dependencies on MTL_TRANSACTION_TYPES

Line 2033: mtl_transaction_types mtt

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

Line 2074: mtl_transaction_types mtt

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