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.AHL_OSP_SHIPMENT_PUB dependencies on INV_ORGANIZATION_INFO_V

Line 1569: --Used inv_organization_info_v instead of org_organization_definitions to fix the Perf Bug #4919255

1565: FROM FINANCIALS_SYSTEM_PARAMETERS FSP,
1566: GL_SETS_OF_BOOKS GSB
1567: WHERE FSP.set_of_books_id = GSB.set_of_books_id;
1568:
1569: --Used inv_organization_info_v instead of org_organization_definitions to fix the Perf Bug #4919255
1570: CURSOR ahl_ship_from_orgs_csr(p_name IN VARCHAR2) IS
1571: SELECT org.organization_id
1572: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def
1573: WHERE org.organization_id = def.organization_id

Line 1572: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def

1568:
1569: --Used inv_organization_info_v instead of org_organization_definitions to fix the Perf Bug #4919255
1570: CURSOR ahl_ship_from_orgs_csr(p_name IN VARCHAR2) IS
1571: SELECT org.organization_id
1572: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def
1573: WHERE org.organization_id = def.organization_id
1574: -- Changed by jaramana on Sep 9, 2005 for MOAC Uptake
1575: -- AND def.operating_unit = FND_PROFILE.VALUE('DEFAULT_ORG_ID')
1576: AND def.operating_unit = MO_GLOBAL.get_current_org_id()

Line 3917: --Used inv_organization_info_v instead of org_organization_definitions to fix the Perf Bug #4919255

3913: payment_term_id
3914: FROM oe_order_headers_all
3915: WHERE header_id = p_oe_header_id;
3916:
3917: --Used inv_organization_info_v instead of org_organization_definitions to fix the Perf Bug #4919255
3918: CURSOR ahl_ship_from_orgs_csr(p_name IN VARCHAR2) IS
3919: SELECT org.organization_id
3920: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def
3921: WHERE org.organization_id = def.organization_id

Line 3920: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def

3916:
3917: --Used inv_organization_info_v instead of org_organization_definitions to fix the Perf Bug #4919255
3918: CURSOR ahl_ship_from_orgs_csr(p_name IN VARCHAR2) IS
3919: SELECT org.organization_id
3920: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def
3921: WHERE org.organization_id = def.organization_id
3922: -- Changed by jaramana on Sep 9, 2005 for MOAC Uptake
3923: -- AND def.operating_unit = FND_PROFILE.VALUE('DEFAULT_ORG_ID')
3924: AND def.operating_unit = MO_GLOBAL.get_current_org_id()