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_SO_MDTR dependencies on HR_ORGANIZATION_INFORMATION

Line 75: --Fix perf bug 4912552, use hr_organization_information to replace

71:
72: --Fix bug 2976193 remove hr_locations_all
73: --Fix bug 3506597, replace confirm_date with initial_pickup_date
74: --Fix bug 3624099, add hints according to Performance team's suggestion
75: --Fix perf bug 4912552, use hr_organization_information to replace
76: --org_organization_definitions according to proposal from INV
77: --karthik.gnanamurthy, because inventory organization is already existing
78: --in rcv_transactions, so it's not required to validate the organization
79: --again in mtl_parameters or hr_all_organization_units as OOD does

Line 99: , hr_organization_information hoi

95: FROM
96: WSH_NEW_DELIVERIES_OB_GRP_V wnd
97: , wsh_delivery_assignments_v wda
98: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
99: , hr_organization_information hoi
100: , OE_ORDER_LINES_ALL ol
101: , OE_ORDER_HEADERS_ALL oh
102: , HZ_CUST_SITE_USES_ALL ras
103: WHERE wnd.delivery_id = wda.delivery_id

Line 136: , hr_organization_information hoi

132: FROM
133: WSH_NEW_DELIVERIES_OB_GRP_V wnd
134: , wsh_delivery_assignments_v wda
135: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
136: , hr_organization_information hoi
137: , OE_ORDER_LINES_ALL ol
138: , OE_ORDER_HEADERS_ALL oh
139: , HZ_CUST_SITE_USES_ALL ras
140: WHERE wnd.delivery_id = wda.delivery_id

Line 176: , hr_organization_information hoi

172: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
173: , OE_ORDER_LINES_ALL ol
174: , OE_ORDER_HEADERS_ALL oh
175: , HZ_CUST_SITE_USES_ALL ras
176: , hr_organization_information hoi
177: WHERE wnd.delivery_id = wda.delivery_id
178: AND wda.delivery_detail_id = wdd.delivery_detail_id
179: AND wdd.source_line_id = ol.line_id
180: AND ol.header_id = oh.header_id

Line 288: , hr_organization_information hoi /Bug 8467743/

284: WSH_NEW_DELIVERIES_OB_GRP_V wnd
285: , wsh_delivery_assignments_v wda
286: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
287: , OE_ORDER_LINES_ALL ol
288: , hr_organization_information hoi /*Bug 8467743*/
289: WHERE wnd.delivery_id = wda.delivery_id
290: AND wda.delivery_detail_id = wdd.delivery_detail_id
291: AND wdd.source_line_id = ol.line_id
292: AND wdd.source_code = 'OE'

Line 664: HR_ORGANIZATION_INFORMATION HOI1

660: TO_NUMBER(HOI2.ORG_INFORMATION3)
661: INTO
662: l_shipment_transaction.org_id
663: FROM
664: HR_ORGANIZATION_INFORMATION HOI1
665: , HR_ORGANIZATION_INFORMATION HOI2
666: , MTL_PARAMETERS MP
667: WHERE MP.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
668: AND MP.ORGANIZATION_ID = HOI2.ORGANIZATION_ID

Line 665: , HR_ORGANIZATION_INFORMATION HOI2

661: INTO
662: l_shipment_transaction.org_id
663: FROM
664: HR_ORGANIZATION_INFORMATION HOI1
665: , HR_ORGANIZATION_INFORMATION HOI2
666: , MTL_PARAMETERS MP
667: WHERE MP.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
668: AND MP.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
669: AND HOI1.ORG_INFORMATION1 = 'INV'