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 135: , hr_organization_information hoi

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

Line 174: , hr_organization_information hoi

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

Line 625: HR_ORGANIZATION_INFORMATION HOI1

621: TO_NUMBER(HOI2.ORG_INFORMATION3)
622: INTO
623: l_shipment_transaction.org_id
624: FROM
625: HR_ORGANIZATION_INFORMATION HOI1
626: , HR_ORGANIZATION_INFORMATION HOI2
627: , MTL_PARAMETERS MP
628: WHERE MP.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
629: AND MP.ORGANIZATION_ID = HOI2.ORGANIZATION_ID

Line 626: , HR_ORGANIZATION_INFORMATION HOI2

622: INTO
623: l_shipment_transaction.org_id
624: FROM
625: HR_ORGANIZATION_INFORMATION HOI1
626: , HR_ORGANIZATION_INFORMATION HOI2
627: , MTL_PARAMETERS MP
628: WHERE MP.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
629: AND MP.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
630: AND HOI1.ORG_INFORMATION1 = 'INV'