[Home] [Help]
7281: --(p_txn_type = WIP_CONSTANTS.MOVE_TXN AND
7282: -- l_mandatory_scrap_flag = WIP_CONSTANTS.YES))) THEN
7283:
7284: UPDATE mtl_material_transactions_temp
7285: SET transaction_temp_id = mtl_material_transactions_s.nextval
7286: WHERE transaction_header_id = p_mtl_header_id
7287: AND transaction_temp_id IS NULL
7288: AND transaction_action_id = p_txn_action_id
7289: AND transaction_type_id = p_txn_type_id
7456: GOTO END_txn;
7457: END IF;
7458:
7459: UPDATE mtl_material_transactions_temp mmtt1
7460: SET mmtt1.transaction_temp_id = mtl_material_transactions_s.nextval
7461: WHERE mmtt1.rowid IN
7462: (SELECT mmtt1.rowid
7463: FROM wip_move_txn_interface wmti,
7464: -- wip_parameters wp,
8009:
8010: /* Generate a mtl txn header id IF one has not already been generated */
8011: IF(p_gib.mtl_header_id IS NULL OR
8012: p_gib.mtl_header_id = -1) THEN
8013: SELECT mtl_material_transactions_s.nextval
8014: INTO p_gib.mtl_header_id
8015: FROM DUAL;
8016: END IF;
8017:
8082: DECODE(p_gib.program_id,-1,NULL,p_gib.program_id),
8083: DECODE(p_gib.request_id,
8084: -1,NULL,SYSDATE), -- program_update_date
8085: p_gib.mtl_header_id, -- transaction_header_id
8086: mtl_material_transactions_s.nextval, -- transaction_temp_id
8087: wmti.source_code,
8088: wmti.source_line_id,
8089: l_transaction_mode, -- transaction_mode
8090: wmti.primary_item_id, -- inventory_item_id
8207: posting_flag,
8208: transaction_batch_id,
8209: transaction_batch_seq
8210: )
8211: SELECT mtl_material_transactions_s.nextval, -- material_alloc_id
8212: wmti.last_updated_by, -- last_updated_by --Fix for bug 5195072
8213: SYSDATE, -- last_update_date
8214: DECODE(p_gib.login_id,-1,NULL,p_gib.login_id),
8215: wmti.created_by, -- created_by --Fix for bug 5195072
8219: DECODE(p_gib.program_id,-1,NULL,p_gib.program_id),
8220: DECODE(p_gib.request_id,
8221: -1,NULL,SYSDATE), -- program_update_date
8222: p_gib.mtl_header_id, -- transaction_header_id
8223: mtl_material_transactions_s.nextval, -- transaction_temp_id
8224: wmti.source_code,
8225: wmti.source_line_id,
8226: l_transaction_mode, -- transaction_mode
8227: wmti.primary_item_id, -- inventory_item_id
8474:
8475: /* Generate a mtl txn header id IF one has not already been generated */
8476: IF(p_gib.mtl_header_id IS NULL OR
8477: p_gib.mtl_header_id = -1) THEN
8478: SELECT mtl_material_transactions_s.nextval
8479: INTO p_gib.mtl_header_id
8480: FROM DUAL;
8481: END IF;
8482:
8483: IF(p_gib.assy_header_id IS NULL OR
8484: p_gib.assy_header_id = -1) THEN
8485: -- Generate new header ID for assembly records because we want inventory
8486: -- to process assembly records, but not component records.
8487: SELECT mtl_material_transactions_s.nextval
8488: INTO p_gib.assy_header_id
8489: FROM DUAL;
8490: END IF;
8491:
8577: -1, NULL, SYSDATE), -- program_update_date
8578: p_gib.assy_header_id, -- transaction_header_id
8579: 'WIP Completion', -- source_code
8580: NVL(p_gib.move_profile.cmp_txn_id,-- completion_transaction_id
8581: mtl_material_transactions_s.nextval),
8582: wmti.transaction_id, -- move_transaction_id
8583: wmti.primary_item_id, -- inventory_item_id
8584: wdj.completion_subinventory, -- subinventory_code
8585: wdj.completion_locator_id, -- locator_id
8624: wmti.wip_entity_id, -- source_header_id
8625: wop.operation_seq_num, -- source_line_id
8626: p_gib.assy_header_id, -- transaction_batch_id
8627: WIP_CONSTANTS.ASSY_BATCH_SEQ,-- transaction_batch_seq
8628: mtl_material_transactions_s.nextval, -- transaction_interface_id
8629: -- populate this value for EZ completion/return because
8630: -- material processor need this value to enable quality
8631: wmti.qa_collection_id
8632: FROM wip_move_txn_interface wmti,
8717: -1, NULL, SYSDATE), -- program_update_date
8718: p_gib.assy_header_id, -- transaction_header_id
8719: 'WIP Completion', -- source_code
8720: NVL(p_gib.move_profile.cmp_txn_id, -- completion_transaction_id
8721: mtl_material_transactions_s.nextval),
8722: wmti.transaction_id, -- move_transaction_id
8723: wmti.primary_item_id, -- inventory_item_id
8724: wri.completion_subinventory,-- subinventory_code
8725: wri.completion_locator_id, -- locator_id
8758: wmti.wip_entity_id, -- source_header_id
8759: wop.operation_seq_num, -- source_line_id
8760: p_gib.assy_header_id, -- transaction_batch_id
8761: WIP_CONSTANTS.ASSY_BATCH_SEQ, -- transaction_batch_seq
8762: mtl_material_transactions_s.nextval, -- transaction_interface_id
8763: -- populate this value for EZ completion/return because
8764: -- material processor need this value to enable quality
8765: wmti.qa_collection_id
8766: FROM wip_move_txn_interface wmti,
8865: mti.last_update_date,
8866: mti.last_updated_by,
8867: mti.last_update_login,
8868: DECODE(msi.serial_number_control_code,
8869: WIP_CONSTANTS.FULL_SN, mtl_material_transactions_s.nextval,
8870: WIP_CONSTANTS.DYN_RCV_SN,mtl_material_transactions_s.nextval,
8871: NULL)
8872: FROM mtl_transactions_interface mti,
8873: mtl_system_items msi,
8866: mti.last_updated_by,
8867: mti.last_update_login,
8868: DECODE(msi.serial_number_control_code,
8869: WIP_CONSTANTS.FULL_SN, mtl_material_transactions_s.nextval,
8870: WIP_CONSTANTS.DYN_RCV_SN,mtl_material_transactions_s.nextval,
8871: NULL)
8872: FROM mtl_transactions_interface mti,
8873: mtl_system_items msi,
8874: wip_discrete_jobs wdj
10088: IF(l_gib.bf_mode = WIP_CONSTANTS.ONLINE) THEN
10089: IF(p_do_backflush = fnd_api.g_true) THEN
10090: IF(l_gib.mtl_header_id IS NULL OR
10091: l_gib.mtl_header_id = -1) THEN
10092: SELECT mtl_material_transactions_s.nextval
10093: INTO l_gib.mtl_header_id
10094: FROM DUAL;
10095: END IF;
10096: