[Home] [Help]
467:
468: l_remaining_qty := l_split_qty - l_partial_total_qty;
469:
470: if( p_current_index = l_count AND l_remaining_qty > 0 ) then
471: select mtl_material_transactions_s.nextval
472: into l_transaction_interface_id --J-dev
473: FROM dual;
474: for l_mti_csr in mti_csr(p_parent_id ) LOOP
475: IF (l_debug = 1) THEN
1563: /*Bug#14700832 Start*/
1564: l_is_yield_correction NUMBER := 0;
1565: CURSOR check_yield_correction IS
1566: SELECT 1
1567: FROM mtl_material_transactions mmt,mtl_transaction_lot_numbers mtln,
1568: mtl_transactions_interface mti, mtl_transaction_lots_interface mtli
1569: WHERE mti.ROWID = p_rowid
1570: AND mtli.ROWID = p_lot_rowid
1571: AND mmt.transaction_id = mti.transaction_sequence_id
8918: AND (
8919: EXISTS
8920: (
8921: select 1 FROM mtl_serial_numbers msn, mtl_serial_numbers_interface msni,
8922: mtl_transactions_interface mti, mtl_material_transactions_temp mmtt
8923: WHERE msn.serial_number BETWEEN msni.fm_serial_number AND msni.to_serial_number
8924: AND Length(msn.serial_number) = Length(msni.fm_serial_number)
8925: AND msn.current_organization_id = mti.organization_id
8926: AND msn.inventory_item_id = mti.inventory_item_id
8936: (
8937: select msn.serial_number, msn.group_mark_id,mti.transaction_interface_id
8938: FROM mtl_serial_numbers msn, mtl_serial_numbers_interface msni,
8939: mtl_transactions_interface mti,mtl_transaction_lots_interface mtli,
8940: mtl_material_transactions_temp mmtt
8941: WHERE msn.serial_number BETWEEN msni.fm_serial_number AND msni.to_serial_number
8942: AND Length(msn.serial_number) = Length(msni.fm_serial_number)
8943: AND msn.current_organization_id = mti.organization_id
8944: AND msn.inventory_item_id = mti.inventory_item_id
9130: /*OSFM Support for Serialized Lot Items*/
9131:
9132: IF ( l_lt_flow_schedule = 0) THEN
9133:
9134: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (
9135: TRANSACTION_HEADER_ID,
9136: TRANSACTION_TEMP_ID,
9137: SOURCE_CODE,
9138: SOURCE_LINE_ID,
9374: REQUISITION_LINE_ID,
9375: REQUISITION_DISTRIBUTION_ID,
9376: SHIP_TO_LOCATION_ID,
9377: Nvl(completion_transaction_id,DECODE(TRANSACTION_ACTION_ID,31,
9378: MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL,32,MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL,NULL)),--J-dev as wip will pass this to us. For I we need the decode.
9379: ATTRIBUTE_CATEGORY,
9380: ATTRIBUTE1,
9381: ATTRIBUTE2,
9382: ATTRIBUTE3,
9474: );
9475:
9476: ELSE
9477: IF ( l_lt_flow_schedule <> 0 ) THEN
9478: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (
9479: TRANSACTION_HEADER_ID,
9480: TRANSACTION_TEMP_ID,
9481: SOURCE_CODE,
9482: SOURCE_LINE_ID,
9720: MTI.SHIPPABLE_FLAG,
9721: MTI.REQUISITION_LINE_ID,
9722: MTI.REQUISITION_DISTRIBUTION_ID,
9723: MTI.SHIP_TO_LOCATION_ID,
9724: NVL(mti.completion_transaction_id,MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL),
9725: --J-dev as wip may pass this to us in J. NVL for I
9726: MTI.ATTRIBUTE_CATEGORY,
9727: MTI.ATTRIBUTE1,
9728: MTI.ATTRIBUTE2,
9833: --MMTT
9834: --In case for I, use the current statement.
9835:
9836: IF (wip_constants.DMF_PATCHSET_LEVEL>= wip_constants.DMF_PATCHSET_J_VALUE) THEN
9837: INSERT INTO mtl_material_transactions_temp
9838: (
9839: TRANSACTION_HEADER_ID,
9840: TRANSACTION_TEMP_ID,
9841: SOURCE_CODE,
10169: and MTI.TRANSACTION_ACTION_ID IN (1, 27, 33, 34) ;
10170:
10171: ELSE
10172:
10173: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (
10174: TRANSACTION_HEADER_ID,
10175: TRANSACTION_TEMP_ID,
10176: SOURCE_CODE,
10177: SOURCE_LINE_ID,
10487: mti.RELIEVE_RESERVATIONS_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
10488: mti.RELIEVE_HIGH_LEVEL_RSV_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
10489: mti.TRANSFER_PRICE -- INVCONV umoogala For Process-Discrete Transfer Enh.
10490: FROM MTL_TRANSACTIONS_INTERFACE MTI,
10491: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
10492: WHERE MTI.TRANSACTION_HEADER_ID = p_header_id
10493: /* WHERE MTI.ROWID = p_rowid J-dev*/
10494: and MTI.PROCESS_FLAG = 1
10495: and MTI.TRANSACTION_ACTION_ID IN (1, 27, 33, 34)
12180: THEN
12181: mydebug ('breadcrumb 30','tmpinsert2');
12182: END IF;
12183:
12184: INSERT INTO mtl_material_transactions_temp
12185: (transaction_header_id
12186: , transaction_temp_id
12187: , source_code
12188: , source_line_id
12421: , l_mti_csr.requisition_distribution_id
12422: , l_mti_csr.ship_to_location_id
12423: , NVL (l_mti_csr.completion_transaction_id
12424: , DECODE (l_mti_csr.transaction_action_id
12425: , 31, mtl_material_transactions_s.NEXTVAL
12426: , 32, mtl_material_transactions_s.NEXTVAL
12427: , NULL
12428: )
12429: )
12422: , l_mti_csr.ship_to_location_id
12423: , NVL (l_mti_csr.completion_transaction_id
12424: , DECODE (l_mti_csr.transaction_action_id
12425: , 31, mtl_material_transactions_s.NEXTVAL
12426: , 32, mtl_material_transactions_s.NEXTVAL
12427: , NULL
12428: )
12429: )
12430: , l_mti_csr.attribute_category
13460: /******************************************************************************
13461: *Lot translate transaction. Users are not expected to populate the MSNIs for *
13462: *Lot Translate txns. We need to generate the MSNTs based on MTLIs and MSN. *
13463: ******************************************************************************/
13464: SELECT mtl_material_transactions_s.NEXTVAL
13465: INTO l_sequence
13466: FROM DUAL;
13467: /******************************************************************************
13468: *If this is the resulting MTIs then we need to query the against the source *