112: l_txnDate,
113: l_assetNum,
114: l_assetGrpID
115: from mtl_material_transactions_temp mmtt,
116: wip_discrete_jobs wdj
117: where wdj.wip_entity_id = mmtt.transaction_source_id
118: and mmtt.transaction_temp_id = p_tempId;
119:
120: --call genealogy API whether or not a serial exists. The eam procedure