DBA Data[Home] [Help]

APPS.WMA_COMPLETION dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 300: values (mtl_material_transactions_s.nextval,

296: final_completion_flag,
297: qa_collection_id,
298: kanban_card_id,
299: lpn_id)
300: values (mtl_material_transactions_s.nextval,
301: mtl_material_transactions_s.nextval,
302: lpnCmpRecord.row.completion_transaction_id,
303: lpnCmpRecord.row.transaction_mode,
304: lpnCmpRecord.row.created_by,

Line 301: mtl_material_transactions_s.nextval,

297: qa_collection_id,
298: kanban_card_id,
299: lpn_id)
300: values (mtl_material_transactions_s.nextval,
301: mtl_material_transactions_s.nextval,
302: lpnCmpRecord.row.completion_transaction_id,
303: lpnCmpRecord.row.transaction_mode,
304: lpnCmpRecord.row.created_by,
305: lpnCmpRecord.row.creation_date,

Line 503: select mtl_material_transactions_s.nextval

499: if(parameters.transactionIntID is null or parameters.transactionIntID <= 0) then
500: if (l_logLevel <= wip_constants.full_logging) then
501: wip_logger.log('wmapcmpb.derive: selecting new int id', l_dummy);
502: end if;
503: select mtl_material_transactions_s.nextval
504: into cmpRecord.transaction_interface_id
505: from dual;
506: else
507: if (l_logLevel <= wip_constants.full_logging) then