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.INV_MGD_MVT_PO_MDTR dependencies on RCV_TRANSACTIONS

Line 93: --in rcv_transactions, so it's not required to validate the organization

89:
90: --Fix performance bug 4912552, use hr_organization_information to replace
91: --org_organization_definitions according to proposal from INV
92: --karthik.gnanamurthy, because inventory organization is already existing
93: --in rcv_transactions, so it's not required to validate the organization
94: --again in mtl_parameters or hr_all_organization_units as OOD does
95: IF NVL(p_movement_transaction.creation_method,'A') = 'A' THEN
96:
97: OPEN po_crsr FOR

Line 111: RCV_TRANSACTIONS rcv

107: , rcv.transaction_date
108: , rcv.organization_id
109: , rcv.subinventory
110: FROM
111: RCV_TRANSACTIONS rcv
112: , hr_organization_information hoi
113: WHERE rcv.organization_id = hoi.organization_id
114: AND hoi.org_information_context = 'Accounting Information'
115: AND rcv.mvt_stat_status = 'NEW'

Line 138: RCV_TRANSACTIONS rcv

134: , rcv.transaction_date
135: , rcv.organization_id
136: , rcv.subinventory
137: FROM
138: RCV_TRANSACTIONS rcv
139: ,RCV_SHIPMENT_HEADERS rsh
140: ,hr_organization_information hoi
141: WHERE rcv.shipment_header_id = rsh.shipment_header_id
142: AND rcv.organization_id = hoi.organization_id

Line 212: rcv_transactions

208: CURSOR l_rt IS
209: SELECT
210: transaction_id
211: FROM
212: rcv_transactions
213: WHERE po_header_id = x_movement_transaction.po_header_id
214: AND po_line_id = x_movement_transaction.po_line_id
215: AND po_line_location_id = x_movement_transaction.po_line_location_id
216: AND transaction_type = 'RECEIVE'

Line 407: RCV_TRANSACTIONS po

403: , po.po_release_id
404: , poh.type_lookup_code
405: , po.consigned_flag
406: FROM
407: RCV_TRANSACTIONS po
408: , RCV_SHIPMENT_HEADERS rsh
409: , RCV_SHIPMENT_LINES rsl
410: , PO_HEADERS_ALL poh
411: , PO_LINES_ALL pol

Line 455: rcv_transactions

451: SELECT
452: SUM(quantity)
453: , SUM(primary_quantity)
454: FROM
455: rcv_transactions
456: WHERE parent_transaction_id = x_movement_transaction.rcv_transaction_id
457: AND mvt_stat_status = 'NEW'
458: AND transaction_type = 'CORRECT';
459:

Line 875: , p_mvt_stat_status IN RCV_TRANSACTIONS.mvt_stat_status%TYPE /Bug 7165989 /

871:
872: PROCEDURE Update_PO_Transactions
873: ( p_movement_transaction IN
874: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
875: , p_mvt_stat_status IN RCV_TRANSACTIONS.mvt_stat_status%TYPE /*Bug 7165989 */
876: , x_return_status OUT NOCOPY VARCHAR2
877: )
878: IS
879: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;

Line 893: /* 7165989 - Update mvt_stat_status in RCV_TRANSACTIONS based of the records */

889:
890: x_return_status := 'Y';
891:
892: -- Update the transaction table
893: /* 7165989 - Update mvt_stat_status in RCV_TRANSACTIONS based of the records */
894: /* created for the RMA triangulation. Any non-RMA triangulation should be stamped*/
895: /* with PROCESSED status*/
896: IF (p_mvt_stat_status is NULL OR (p_mvt_stat_status <> 'FORDISP'
897: AND p_mvt_stat_status <> 'FORARVL') )

Line 900: UPDATE RCV_TRANSACTIONS

896: IF (p_mvt_stat_status is NULL OR (p_mvt_stat_status <> 'FORDISP'
897: AND p_mvt_stat_status <> 'FORARVL') )
898: THEN
899:
900: UPDATE RCV_TRANSACTIONS
901: SET mvt_stat_status = 'PROCESSED'
902: , movement_id = p_movement_transaction.movement_id
903: WHERE transaction_id = p_movement_transaction.rcv_transaction_id;
904: ELSE

Line 905: UPDATE RCV_TRANSACTIONS

901: SET mvt_stat_status = 'PROCESSED'
902: , movement_id = p_movement_transaction.movement_id
903: WHERE transaction_id = p_movement_transaction.rcv_transaction_id;
904: ELSE
905: UPDATE RCV_TRANSACTIONS
906: SET mvt_stat_status = p_mvt_stat_status
907: , movement_id = p_movement_transaction.movement_id
908: WHERE transaction_id = p_movement_transaction.rcv_transaction_id;
909: END IF;

Line 965: FROM RCV_TRANSACTIONS

961: OPEN rtv_crsr FOR
962: SELECT NVL(vendor_site_id,null)
963: , NVL(parent_transaction_id,null)
964: , transaction_type
965: FROM RCV_TRANSACTIONS
966: WHERE transaction_id = p_parent_id;
967:
968: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
969: THEN

Line 1011: RCV_TRANSACTIONS po

1007: po.po_release_id
1008: , po.po_line_location_id
1009: , poh.type_lookup_code
1010: FROM
1011: RCV_TRANSACTIONS po
1012: , PO_HEADERS_ALL poh
1013: WHERE po.po_header_id = poh.po_header_id
1014: AND po.transaction_id = x_movement_transaction.rcv_transaction_id;
1015:

Line 1094: --in rcv_transactions, so it's not required to validate the organization

1090:
1091: --Fix performance bug 4912552, use hr_organization_information to replace
1092: --org_organization_definitions according to proposal from INV
1093: --karthik.gnanamurthy, because inventory organization is already existing
1094: --in rcv_transactions, so it's not required to validate the organization
1095: --again in mtl_parameters or hr_all_organization_units as OOD does
1096: --Fix bug 5437773, replace oola.sold_from_org_id with oola.org_id
1097: --org_id is the correct column to get operating unit
1098:

Line 1119: RCV_TRANSACTIONS rcv

1115: , rcv.organization_id
1116: , rcv.subinventory
1117: , rcv.mvt_stat_status -- 7165989
1118: FROM
1119: RCV_TRANSACTIONS rcv
1120: , oe_order_lines_all oola
1121: WHERE rcv.oe_order_line_id = oola.line_id
1122: AND rcv.mvt_stat_status IN ('NEW', 'FORDISP', 'FORARVL') -- 7165989 Changes for RMA triangulation
1123: AND rcv.transaction_type IN ('DELIVER')

Line 1144: RCV_TRANSACTIONS rcv

1140: , rcv.organization_id
1141: , rcv.subinventory
1142: , rcv.mvt_stat_status -- 7165989
1143: FROM
1144: RCV_TRANSACTIONS rcv
1145: , hr_organization_information hoi
1146: WHERE rcv.organization_id = hoi.organization_id
1147: AND hoi.org_information_context = 'Accounting Information'
1148: AND hoi.org_information2 = to_char(p_movement_transaction.entity_org_id) /* bug 7676431: Added to_char */

Line 1168: RCV_TRANSACTIONS rcv

1164: , rcv.organization_id
1165: , rcv.subinventory
1166: , rcv.mvt_stat_status -- 7165989
1167: FROM
1168: RCV_TRANSACTIONS rcv
1169: , RCV_SHIPMENT_HEADERS rsh
1170: , oe_order_lines_all oola
1171: WHERE rcv.shipment_header_id = rsh.shipment_header_id
1172: AND rcv.oe_order_line_id = oola.line_id

Line 1195: RCV_TRANSACTIONS rcv

1191: , rcv.organization_id
1192: , rcv.subinventory
1193: , rcv.mvt_stat_status -- 7165989
1194: FROM
1195: RCV_TRANSACTIONS rcv
1196: , RCV_SHIPMENT_HEADERS rsh
1197: , hr_organization_information hoi
1198: WHERE rcv.shipment_header_id = rsh.shipment_header_id
1199: AND rcv.organization_id = hoi.organization_id

Line 1282: RCV_TRANSACTIONS po

1278: , ooha.org_id
1279: , oola.order_quantity_uom
1280: , ooha.sold_from_org_id -- 7165989
1281: FROM
1282: RCV_TRANSACTIONS po
1283: , RCV_SHIPMENT_HEADERS rsh
1284: , RCV_SHIPMENT_LINES rsl
1285: , OE_ORDER_HEADERS_ALL ooha
1286: , OE_ORDER_LINES_ALL oola

Line 1541: --in rcv_transactions, so it's not required to validate the organization

1537:
1538: --Fix performance bug 4912552, use hr_organization_information to replace
1539: --org_organization_definitions according to proposal from INV
1540: --karthik.gnanamurthy, because inventory organization is already existing
1541: --in rcv_transactions, so it's not required to validate the organization
1542: --again in mtl_parameters or hr_all_organization_units as OOD does
1543:
1544: IF NVL(p_movement_transaction.creation_method,'A') = 'A'
1545: THEN

Line 1547: --io_arrival_crsr so that no duplicate rcv transactions picked

1543:
1544: IF NVL(p_movement_transaction.creation_method,'A') = 'A'
1545: THEN
1546: --Fix bug 3364811, move order lines and delivery table out of
1547: --io_arrival_crsr so that no duplicate rcv transactions picked
1548: OPEN io_arrival_crsr FOR
1549: SELECT
1550: rcv.transaction_id
1551: , rcv.transaction_date

Line 1557: rcv_transactions rcv

1553: , rcv.subinventory
1554: , rcv.requisition_line_id
1555: , prha.segment1
1556: FROM
1557: rcv_transactions rcv
1558: , po_requisition_lines_all prla
1559: , po_requisition_headers_all prha
1560: , oe_order_headers_all orha
1561: , hr_organization_information hoi

Line 1619: l_unit_of_measure rcv_transactions.unit_of_measure%TYPE;

1615: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1616: , x_return_status OUT NOCOPY VARCHAR2
1617: )
1618: IS
1619: l_unit_of_measure rcv_transactions.unit_of_measure%TYPE;
1620: l_transport_mode mtl_movement_statistics.transport_mode%TYPE;
1621: l_document_unit_price mtl_movement_statistics.document_unit_price%TYPE;
1622: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1623: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;

Line 1623: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;

1619: l_unit_of_measure rcv_transactions.unit_of_measure%TYPE;
1620: l_transport_mode mtl_movement_statistics.transport_mode%TYPE;
1621: l_document_unit_price mtl_movement_statistics.document_unit_price%TYPE;
1622: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1623: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;
1624:
1625: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1626: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1627: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;

Line 1654: RCV_TRANSACTIONS rcv

1650: , NVL(rcv.po_unit_price,0)
1651: , rcv.country_of_origin_code
1652: , NVL(rsh.freight_carrier_code,'3')
1653: FROM
1654: RCV_TRANSACTIONS rcv
1655: , RCV_SHIPMENT_HEADERS rsh
1656: , RCV_SHIPMENT_LINES rsl
1657: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
1658: WHERE rcv.shipment_header_id = rsh.shipment_header_id