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
8804: REQUISITION_LINE_ID,
8805: REQUISITION_DISTRIBUTION_ID,
8806: SHIP_TO_LOCATION_ID,
8807: Nvl(completion_transaction_id,DECODE(TRANSACTION_ACTION_ID,31,
8808: 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.
8809: ATTRIBUTE_CATEGORY,
8810: ATTRIBUTE1,
8811: ATTRIBUTE2,
8812: ATTRIBUTE3,
9149: MTI.SHIPPABLE_FLAG,
9150: MTI.REQUISITION_LINE_ID,
9151: MTI.REQUISITION_DISTRIBUTION_ID,
9152: MTI.SHIP_TO_LOCATION_ID,
9153: NVL(mti.completion_transaction_id,MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL),
9154: --J-dev as wip may pass this to us in J. NVL for I
9155: MTI.ATTRIBUTE_CATEGORY,
9156: MTI.ATTRIBUTE1,
9157: MTI.ATTRIBUTE2,
11850: , l_mti_csr.requisition_distribution_id
11851: , l_mti_csr.ship_to_location_id
11852: , NVL (l_mti_csr.completion_transaction_id
11853: , DECODE (l_mti_csr.transaction_action_id
11854: , 31, mtl_material_transactions_s.NEXTVAL
11855: , 32, mtl_material_transactions_s.NEXTVAL
11856: , NULL
11857: )
11858: )
11851: , l_mti_csr.ship_to_location_id
11852: , NVL (l_mti_csr.completion_transaction_id
11853: , DECODE (l_mti_csr.transaction_action_id
11854: , 31, mtl_material_transactions_s.NEXTVAL
11855: , 32, mtl_material_transactions_s.NEXTVAL
11856: , NULL
11857: )
11858: )
11859: , l_mti_csr.attribute_category
12889: /******************************************************************************
12890: *Lot translate transaction. Users are not expected to populate the MSNIs for *
12891: *Lot Translate txns. We need to generate the MSNTs based on MTLIs and MSN. *
12892: ******************************************************************************/
12893: SELECT mtl_material_transactions_s.NEXTVAL
12894: INTO l_sequence
12895: FROM DUAL;
12896: /******************************************************************************
12897: *If this is the resulting MTIs then we need to query the against the source *