[Home] [Help]
6314: Account */
6315:
6316: select nvl(rt.dropship_type_code, 3)
6317: into l_dropship_type_code
6318: from rcv_transactions rt, mtl_material_transactions mmt
6319: where mmt.rcv_transaction_id = rt.transaction_id
6320: and mmt.transaction_id = i_ae_txn_rec.transaction_id;
6321:
6322: if (l_dropship_type_code = 1 or l_dropship_type_code = 2) then
9111: -- For action id 22, transfer_transaction_id points to receiving txn, not the shipping txn,
9112: -- because it got created after goods are received, so goto else part...
9113: decode(l_pd_txfr_ind, 1, 0, nvl(MMT.transfer_transaction_id, 0))
9114: INTO l_ship_num, l_req_line, l_txf_txn_id
9115: FROM mtl_material_transactions MMT, rcv_transactions RT
9116: WHERE MMT.transaction_id = i_ae_txn_rec.transaction_id
9117: AND RT.transaction_id = MMT.rcv_transaction_id;
9118:
9119:
10705: * Int Req Direct Org Xfr (95, 3, 7),
10706: * Int Order Direct Ship (54, 3, 8): TRX_SOURCE_LINE_ID = OE_ORDER_LINE_ID.LINE_ID
10707: * For Internal Req Intr Rcpt (61, 12, 7) and its adjustment (72, 29, 7):
10708: * TRANSACTION_SOURCE_ID = REQUISITION_HEADER_ID, also RCV_TRANSACTION_ID is populated
10709: * which provides the requisition_line_id from RCV_TRANSACTIONS */
10710: IF ( ( l_txn_action_id = 3
10711: AND l_txn_src_type_id = 7 ) OR
10712: ( l_txn_action_id = 3
10713: AND l_txn_src_type_id = 8 ) OR
10731: REQUISITION_LINE_ID
10732: INTO
10733: l_req_line_id
10734: FROM
10735: RCV_TRANSACTIONS
10736: WHERE
10737: TRANSACTION_ID = l_rcv_txn_id;
10738: ELSE
10739: RETURN;