eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_RCV_TRANSACTION_SV dependencies on RCV_TRANSACTIONS

Line 68: FROM RCV_TRANSACTIONS RT,

64: INTO X_PRIMARY_UOM,
65: X_ITEM_ID,
66: X_PARENT_TYPE,
67: X_TXN_ORG_ID
68: FROM RCV_TRANSACTIONS RT,
69: RCV_SHIPMENT_LINES RL,
70: PO_HEADERS_ALL PH,
71: OE_ORDER_HEADERS_ALL OH
72: WHERE RT.TRANSACTION_ID = P_PARENT_TRANSACTION_ID

Line 146: from rcv_transactions rt1,

142: select rt2.transaction_type,
143: rt2.transaction_id
144: into x_grandparent_type,
145: x_grandparent_id
146: from rcv_transactions rt1,
147: rcv_transactions rt2
148: where rt1.transaction_id = p_parent_transaction_id
149: and rt2.transaction_id = rt1.parent_transaction_id;
150:

Line 147: rcv_transactions rt2

143: rt2.transaction_id
144: into x_grandparent_type,
145: x_grandparent_id
146: from rcv_transactions rt1,
147: rcv_transactions rt2
148: where rt1.transaction_id = p_parent_transaction_id
149: and rt2.transaction_id = rt1.parent_transaction_id;
150:
151: -- correct receive first if qty is +'ve

Line 191: from rcv_transactions rt1,

187: select rt2.transaction_type,
188: rt2.transaction_id
189: into x_grandparent_type,
190: x_grandparent_id
191: from rcv_transactions rt1,
192: rcv_transactions rt2
193: where rt1.transaction_id = p_parent_transaction_id
194: and rt2.transaction_id = rt1.parent_transaction_id;
195:

Line 192: rcv_transactions rt2

188: rt2.transaction_id
189: into x_grandparent_type,
190: x_grandparent_id
191: from rcv_transactions rt1,
192: rcv_transactions rt2
193: where rt1.transaction_id = p_parent_transaction_id
194: and rt2.transaction_id = rt1.parent_transaction_id;
195:
196: -- correct deliver first if qty is -'ve

Line 369: rcv_transactions

365: nvl(quantity, amount),
366: transaction_type,
367: parent_transaction_id
368: FROM
369: rcv_transactions
370: START WITH transaction_id = c_transaction_id
371: CONNECT BY parent_transaction_id = PRIOR transaction_id;
372:
373: begin

Line 409: rcv_transactions

405: transaction_type
406: INTO
407: v_parent_type
408: FROM
409: rcv_transactions
410: WHERE
411: transaction_id = v_parent_id;
412:
413: IF v_parent_type = 'DELIVER' THEN

Line 451: rcv_transactions

447: quantity,
448: transaction_type,
449: parent_transaction_id
450: FROM
451: rcv_transactions
452: START WITH transaction_id = c_transaction_id
453: CONNECT BY parent_transaction_id = PRIOR transaction_id;
454:
455: begin

Line 484: rcv_transactions

480: transaction_type
481: INTO
482: v_parent_type
483: FROM
484: rcv_transactions
485: WHERE
486: transaction_id = v_parent_id;
487:
488: IF v_parent_type in ('RETURN TO RECEIVING', 'RETURN TO VENDOR') THEN

Line 528: from po_vendor_sites povs, rcv_transactions rt

524: begin
525: if fnd_profile.Value('POR_ENABLE_DEBIT_MEMO') = 'Y' then
526: select povs.create_debit_memo_flag
527: into x_create_debit_memo_flag
528: from po_vendor_sites povs, rcv_transactions rt
529: where povs.vendor_site_id = rt.vendor_site_id
530: and rt.transaction_id = p_parent_transaction_id;
531: else
532: x_create_debit_memo_flag := 'N';

Line 545: from rcv_transactions rt

541: p_txn_qty < 0
542: then
543: select rt.subinventory, rt.locator_id
544: into x_from_subinventory, x_from_locator_id
545: from rcv_transactions rt
546: where rt.transaction_id = p_parent_transaction_id;
547: else
548: select rt.from_subinventory, rt.from_locator_id
549: into x_from_subinventory, x_from_locator_id

Line 550: from rcv_transactions rt

546: where rt.transaction_id = p_parent_transaction_id;
547: else
548: select rt.from_subinventory, rt.from_locator_id
549: into x_from_subinventory, x_from_locator_id
550: from rcv_transactions rt
551: where rt.transaction_id = p_parent_transaction_id;
552: end if;
553:
554: -- Setting validation flag to Y for ROI

Line 556: insert into RCV_TRANSACTIONS_INTERFACE

552: end if;
553:
554: -- Setting validation flag to Y for ROI
555:
556: insert into RCV_TRANSACTIONS_INTERFACE
557: ( receipt_source_code,
558: interface_transaction_id,
559: group_id,
560: org_id,

Line 653: RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,

649: job_id,
650: matching_basis)
651: select
652: rh.receipt_source_code,
653: RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
654: p_group_id,
655: MO_GLOBAL.get_current_org_id,
656: SYSDATE,
657: fnd_global.user_id,

Line 746: from rcv_transactions rt,

742: rt.vendor_site_id,
743: x_create_debit_memo_flag,
744: rt.job_id,
745: pol.matching_basis
746: from rcv_transactions rt,
747: rcv_shipment_lines rl,
748: rcv_shipment_headers rh,
749: mtl_system_items msi,
750: po_Lines_all pol

Line 774: from rcv_transactions rt1,

770: select rt2.transaction_id,
771: rt2.parent_transaction_id
772: into x_deliver_id,
773: x_receive_id
774: from rcv_transactions rt1,
775: rcv_transactions rt2
776: where rt1.parent_transaction_id = rt2.transaction_id
777: and rt1.transaction_id = p_transaction_id;
778:

Line 775: rcv_transactions rt2

771: rt2.parent_transaction_id
772: into x_deliver_id,
773: x_receive_id
774: from rcv_transactions rt1,
775: rcv_transactions rt2
776: where rt1.parent_transaction_id = rt2.transaction_id
777: and rt1.transaction_id = p_transaction_id;
778:
779: -- Get the RTV transaction

Line 783: from rcv_transactions

779: -- Get the RTV transaction
780:
781: select min(transaction_id)
782: into x_rtv_id
783: from rcv_transactions
784: where parent_transaction_id = x_receive_id
785: and transaction_type = 'RETURN TO VENDOR'
786: and get_net_returned_qty(transaction_id) = get_net_returned_qty(p_transaction_id);
787: