[Home] [Help]
781: rt6.transaction_id
782: INTO
783: l_par_rcv_txn
784: FROM
785: rcv_transactions rt6
786: where rt6.transaction_type = 'RECEIVE'
787: START WITH
788: rt6.transaction_id = l_rcv_txn
789: CONNECT BY
881: l_acq_cost_ent_po
882: FROM
883: cst_rcv_acq_cost_details cracd,
884: po_line_locations_all poll,
885: rcv_transactions rt
886: WHERE
887: poll.line_location_id = cracd.po_line_location_id
888: AND cracd.header_id = (SELECT header_id
889: FROM cst_rcv_acq_costs crac
6599: Account */
6600:
6601: select nvl(rt.dropship_type_code, 3)
6602: into l_dropship_type_code
6603: from rcv_transactions rt, mtl_material_transactions mmt
6604: where mmt.rcv_transaction_id = rt.transaction_id
6605: and mmt.transaction_id = i_ae_txn_rec.transaction_id;
6606:
6607: if (l_dropship_type_code = 1 or l_dropship_type_code = 2) then
9552: -- For action id 22, transfer_transaction_id points to receiving txn, not the shipping txn,
9553: -- because it got created after goods are received, so goto else part...
9554: decode(l_pd_txfr_ind, 1, 0, nvl(MMT.transfer_transaction_id, 0))
9555: INTO l_ship_num, l_req_line, l_txf_txn_id
9556: FROM mtl_material_transactions MMT, rcv_transactions RT
9557: WHERE MMT.transaction_id = i_ae_txn_rec.transaction_id
9558: AND RT.transaction_id = MMT.rcv_transaction_id;
9559:
9560:
11189: * Int Req Direct Org Xfr (95, 3, 7),
11190: * Int Order Direct Ship (54, 3, 8): TRX_SOURCE_LINE_ID = OE_ORDER_LINE_ID.LINE_ID
11191: * For Internal Req Intr Rcpt (61, 12, 7) and its adjustment (72, 29, 7):
11192: * TRANSACTION_SOURCE_ID = REQUISITION_HEADER_ID, also RCV_TRANSACTION_ID is populated
11193: * which provides the requisition_line_id from RCV_TRANSACTIONS */
11194: IF ( ( l_txn_action_id = 3
11195: AND l_txn_src_type_id = 7 ) OR
11196: ( l_txn_action_id = 3
11197: AND l_txn_src_type_id = 8 ) OR
11215: REQUISITION_LINE_ID
11216: INTO
11217: l_req_line_id
11218: FROM
11219: RCV_TRANSACTIONS
11220: WHERE
11221: TRANSACTION_ID = l_rcv_txn_id;
11222: ELSE
11223: RETURN;