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 114: RCV_TRANSACTIONS rcv

110: --Bugfix 13556992: Getting additional information.
111: , rcv.shipment_header_id
112: , rcv.shipment_line_id
113: FROM
114: RCV_TRANSACTIONS rcv
115: , hr_organization_information hoi
116: WHERE rcv.organization_id = hoi.organization_id
117: AND hoi.org_information_context = 'Accounting Information'
118: AND rcv.mvt_stat_status = 'NEW'

Line 144: RCV_TRANSACTIONS rcv

140: --Bugfix 13556992: Getting additional information.
141: , rcv.shipment_header_id
142: , rcv.shipment_line_id
143: FROM
144: RCV_TRANSACTIONS rcv
145: ,RCV_SHIPMENT_HEADERS rsh
146: ,hr_organization_information hoi
147: WHERE rcv.shipment_header_id = rsh.shipment_header_id
148: AND rcv.organization_id = hoi.organization_id

Line 218: rcv_transactions

214: CURSOR l_rt IS
215: SELECT
216: transaction_id
217: FROM
218: rcv_transactions
219: WHERE po_header_id = x_movement_transaction.po_header_id
220: AND po_line_id = x_movement_transaction.po_line_id
221: AND po_line_location_id = x_movement_transaction.po_line_location_id
222: AND transaction_type = 'RECEIVE'

Line 413: RCV_TRANSACTIONS po

409: , po.po_release_id
410: , poh.type_lookup_code
411: , po.consigned_flag
412: FROM
413: RCV_TRANSACTIONS po
414: , RCV_SHIPMENT_HEADERS rsh
415: , RCV_SHIPMENT_LINES rsl
416: , PO_HEADERS_ALL poh
417: , PO_LINES_ALL pol

Line 461: rcv_transactions

457: SELECT
458: SUM(quantity)
459: , SUM(primary_quantity)
460: FROM
461: rcv_transactions
462: WHERE parent_transaction_id = x_movement_transaction.rcv_transaction_id
463: AND mvt_stat_status = 'NEW'
464: AND transaction_type = 'CORRECT';
465:

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

950:
951: PROCEDURE Update_PO_Transactions
952: ( p_movement_transaction IN
953: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
954: , p_mvt_stat_status IN RCV_TRANSACTIONS.mvt_stat_status%TYPE /*Bug 7165989 */
955: , x_return_status OUT NOCOPY VARCHAR2
956: )
957: IS
958: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;

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

968:
969: x_return_status := 'Y';
970:
971: -- Update the transaction table
972: /* 7165989 - Update mvt_stat_status in RCV_TRANSACTIONS based of the records */
973: /* created for the RMA triangulation. Any non-RMA triangulation should be stamped*/
974: /* with PROCESSED status*/
975: IF (p_mvt_stat_status is NULL OR (p_mvt_stat_status <> 'FORDISP'
976: AND p_mvt_stat_status <> 'FORARVL') )

Line 979: UPDATE RCV_TRANSACTIONS

975: IF (p_mvt_stat_status is NULL OR (p_mvt_stat_status <> 'FORDISP'
976: AND p_mvt_stat_status <> 'FORARVL') )
977: THEN
978:
979: UPDATE RCV_TRANSACTIONS
980: SET mvt_stat_status = 'PROCESSED'
981: , movement_id = p_movement_transaction.movement_id
982: WHERE transaction_id = p_movement_transaction.rcv_transaction_id;
983: ELSE

Line 984: UPDATE RCV_TRANSACTIONS

980: SET mvt_stat_status = 'PROCESSED'
981: , movement_id = p_movement_transaction.movement_id
982: WHERE transaction_id = p_movement_transaction.rcv_transaction_id;
983: ELSE
984: UPDATE RCV_TRANSACTIONS
985: SET mvt_stat_status = p_mvt_stat_status
986: , movement_id = p_movement_transaction.movement_id
987: WHERE transaction_id = p_movement_transaction.rcv_transaction_id;
988: END IF;

Line 1044: FROM RCV_TRANSACTIONS

1040: OPEN rtv_crsr FOR
1041: SELECT NVL(vendor_site_id,null)
1042: , NVL(parent_transaction_id,null)
1043: , transaction_type
1044: FROM RCV_TRANSACTIONS
1045: WHERE transaction_id = p_parent_id;
1046:
1047: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1048: THEN

Line 1090: RCV_TRANSACTIONS po

1086: po.po_release_id
1087: , po.po_line_location_id
1088: , poh.type_lookup_code
1089: FROM
1090: RCV_TRANSACTIONS po
1091: , PO_HEADERS_ALL poh
1092: WHERE po.po_header_id = poh.po_header_id
1093: AND po.transaction_id = x_movement_transaction.rcv_transaction_id;
1094:

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

1169:
1170: --Fix performance bug 4912552, use hr_organization_information to replace
1171: --org_organization_definitions according to proposal from INV
1172: --karthik.gnanamurthy, because inventory organization is already existing
1173: --in rcv_transactions, so it's not required to validate the organization
1174: --again in mtl_parameters or hr_all_organization_units as OOD does
1175: --Fix bug 5437773, replace oola.sold_from_org_id with oola.org_id
1176: --org_id is the correct column to get operating unit
1177:

Line 1198: RCV_TRANSACTIONS rcv

1194: , rcv.organization_id
1195: , rcv.subinventory
1196: , rcv.mvt_stat_status -- 7165989
1197: FROM
1198: RCV_TRANSACTIONS rcv
1199: , oe_order_lines_all oola
1200: , hr_organization_information hoi /*Bug 8467743*/
1201: WHERE rcv.oe_order_line_id = oola.line_id
1202: AND rcv.mvt_stat_status IN ('NEW', 'FORDISP', 'FORARVL') -- 7165989 Changes for RMA triangulation

Line 1228: RCV_TRANSACTIONS rcv

1224: , rcv.organization_id
1225: , rcv.subinventory
1226: , rcv.mvt_stat_status -- 7165989
1227: FROM
1228: RCV_TRANSACTIONS rcv
1229: , hr_organization_information hoi
1230: WHERE rcv.organization_id = hoi.organization_id
1231: AND hoi.org_information_context = 'Accounting Information'
1232: AND hoi.org_information2 = to_char(p_movement_transaction.entity_org_id) /* bug 7676431: Added to_char */

Line 1252: RCV_TRANSACTIONS rcv

1248: , rcv.organization_id
1249: , rcv.subinventory
1250: , rcv.mvt_stat_status -- 7165989
1251: FROM
1252: RCV_TRANSACTIONS rcv
1253: , RCV_SHIPMENT_HEADERS rsh
1254: , oe_order_lines_all oola
1255: , hr_organization_information hoi /*Bug 8467743*/
1256: WHERE rcv.shipment_header_id = rsh.shipment_header_id

Line 1284: RCV_TRANSACTIONS rcv

1280: , rcv.organization_id
1281: , rcv.subinventory
1282: , rcv.mvt_stat_status -- 7165989
1283: FROM
1284: RCV_TRANSACTIONS rcv
1285: , RCV_SHIPMENT_HEADERS rsh
1286: , hr_organization_information hoi
1287: WHERE rcv.shipment_header_id = rsh.shipment_header_id
1288: AND rcv.organization_id = hoi.organization_id

Line 1386: RCV_TRANSACTIONS po

1382: , oola.order_quantity_uom
1383: , ooha.sold_from_org_id -- 7165989
1384: , oola.return_attribute2 -- 8435314
1385: FROM
1386: RCV_TRANSACTIONS po
1387: , RCV_SHIPMENT_HEADERS rsh
1388: , RCV_SHIPMENT_LINES rsl
1389: , OE_ORDER_HEADERS_ALL ooha
1390: , OE_ORDER_LINES_ALL oola

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

1692:
1693: --Fix performance bug 4912552, use hr_organization_information to replace
1694: --org_organization_definitions according to proposal from INV
1695: --karthik.gnanamurthy, because inventory organization is already existing
1696: --in rcv_transactions, so it's not required to validate the organization
1697: --again in mtl_parameters or hr_all_organization_units as OOD does
1698:
1699: IF NVL(p_movement_transaction.creation_method,'A') = 'A'
1700: THEN

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

1698:
1699: IF NVL(p_movement_transaction.creation_method,'A') = 'A'
1700: THEN
1701: --Fix bug 3364811, move order lines and delivery table out of
1702: --io_arrival_crsr so that no duplicate rcv transactions picked
1703:
1704: --Bugfix 9839689: Added distinct.
1705:
1706: OPEN io_arrival_crsr FOR

Line 1716: rcv_transactions rcv

1712: , rcv.requisition_line_id
1713: , prha.segment1
1714: , rcv.oe_order_line_id /* Added for bug 9024785*/
1715: FROM
1716: rcv_transactions rcv
1717: , po_requisition_lines_all prla
1718: , po_requisition_headers_all prha
1719: , oe_order_headers_all orha
1720: , hr_organization_information hoi

Line 1778: l_unit_of_measure rcv_transactions.unit_of_measure%TYPE;

1774: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1775: , x_return_status OUT NOCOPY VARCHAR2
1776: )
1777: IS
1778: l_unit_of_measure rcv_transactions.unit_of_measure%TYPE;
1779: l_transport_mode mtl_movement_statistics.transport_mode%TYPE;
1780: l_document_unit_price mtl_movement_statistics.document_unit_price%TYPE;
1781: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1782: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;

Line 1782: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;

1778: l_unit_of_measure rcv_transactions.unit_of_measure%TYPE;
1779: l_transport_mode mtl_movement_statistics.transport_mode%TYPE;
1780: l_document_unit_price mtl_movement_statistics.document_unit_price%TYPE;
1781: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1782: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;
1783:
1784: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1785: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1786: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;

Line 1813: RCV_TRANSACTIONS rcv

1809: , NVL(rcv.po_unit_price,0)
1810: , rcv.country_of_origin_code
1811: , NVL(rsh.freight_carrier_code,'3')
1812: FROM
1813: RCV_TRANSACTIONS rcv
1814: , RCV_SHIPMENT_HEADERS rsh
1815: , RCV_SHIPMENT_LINES rsl
1816: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
1817: WHERE rcv.shipment_header_id = rsh.shipment_header_id