APPS.INV_TXN_MANAGER_GRP dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 471: select mtl_material_transactions_s.nextval

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

Line 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.

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,

Line 9724: NVL(mti.completion_transaction_id,MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL),

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,

Line 12425: , 31, mtl_material_transactions_s.NEXTVAL

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: )

Line 12426: , 32, mtl_material_transactions_s.NEXTVAL

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

Line 13464: SELECT mtl_material_transactions_s.NEXTVAL

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 *