1361: , task
1362: , lpn_number
1363: , transfer_lpn_number
1364: , content_lpn_number
1365: from wsm_inv_txns_wip_lots_v
1366: where object_id = p_material_txn_rec.object_id
1367: and object_type = p_material_txn_rec.object_type
1368: and organization_id = p_material_txn_rec.current_org_id
1369: ;
1424: l_from := ' from mtl_transaction_details_v';
1425: elsif p_material_txn_rec.wip_entity_type in (9, 10) then
1426: l_from := ' from mtl_inv_txns_mfg_lots_v';
1427: else
1428: l_from := ' from wsm_inv_txns_wip_lots_v';
1429: end if;
1430: l_order_by := ' order by transaction_date desc';
1431: l_query := l_select||l_from||l_where||l_order_by;
1432: --debug('Material_txn Query: '||l_query);