APPS.CST_LCMADJUSTMENTS_PVT dependencies on RCV_TRANSACTIONS

Line 588: rcv_transactions rt

584: gl_period_statuses gps,
585: mtl_system_items_b msi,
586: po_headers_all poh,
587: org_acct_periods oap,
588: rcv_transactions rt
589: WHERE li.group_id = p_group_id
590: AND li.organization_id = p_organization_id
591: AND li.process_status = 2
592: AND gps.application_id = G_PO_APPLICATION_ID

Line 642: FROM rcv_transactions rt

638: rt.source_doc_quantity,
639: rt.primary_quantity,
640: rt.subinventory,
641: rt.po_distribution_id
642: FROM rcv_transactions rt
643: WHERE rt.transaction_type IN ('RECEIVE', 'MATCH', 'RETURN TO VENDOR', 'CORRECT', 'DELIVER', 'RETURN TO RECEIVING')
644: AND rt.transaction_date < c_lt.transaction_date
645: START WITH rt.transaction_id = c_lt.rcv_transaction_id
646: CONNECT BY rt.parent_transaction_id = PRIOR rt.transaction_id;

Line 685: FROM rcv_transactions rt_parent,

681: nvl(rae.primary_quantity,rt.primary_quantity),
682: rt.transaction_type,
683: Decode(rt.transaction_type, 'CORRECT', rt_parent.transaction_type, rt.transaction_type) parent_transaction_type,
684: rt.subinventory_code
685: FROM rcv_transactions rt_parent,
686: rcv_accounting_events rae,
687: CST_LC_RCV_TXN_GT rt
688: WHERE rae.rcv_transaction_id (+) = rt.rcv_transaction_id
689: AND Nvl(rae.event_type_id,2) in (1,2,3,4,5,6)

Line 2730: rcv_transactions rt,

2726: mp.lcm_var_account, rp.lcm_account_id, mp.primary_cost_method,
2727: msi.inventory_item_id msi_item_id
2728: FROM org_acct_periods oap,
2729: cst_lc_adj_interface clai,
2730: rcv_transactions rt,
2731: rcv_accounting_events rae,
2732: /* Bug 13960596 po_lines_all pol, */
2733: rcv_shipment_lines rsl,
2734: po_line_locations_all poll,