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 1604: --Used inv_organization_info_v instead of org_organization_definitions to fix the Perf Bug #4919255

1600: FROM FINANCIALS_SYSTEM_PARAMETERS FSP,
1601: GL_SETS_OF_BOOKS GSB
1602: WHERE FSP.set_of_books_id = GSB.set_of_books_id;
1603:
1604: --Used inv_organization_info_v instead of org_organization_definitions to fix the Perf Bug #4919255
1605: CURSOR ahl_ship_from_orgs_csr(p_name IN VARCHAR2) IS
1606: SELECT org.organization_id
1607: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def
1608: WHERE org.organization_id = def.organization_id

Line 1607: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def

1603:
1604: --Used inv_organization_info_v instead of org_organization_definitions to fix the Perf Bug #4919255
1605: CURSOR ahl_ship_from_orgs_csr(p_name IN VARCHAR2) IS
1606: SELECT org.organization_id
1607: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def
1608: WHERE org.organization_id = def.organization_id
1609: -- Changed by jaramana on Sep 9, 2005 for MOAC Uptake
1610: -- AND def.operating_unit = FND_PROFILE.VALUE('DEFAULT_ORG_ID')
1611: AND def.operating_unit = MO_GLOBAL.get_current_org_id()

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

3897: payment_term_id
3898: FROM oe_order_headers_all
3899: WHERE header_id = p_oe_header_id;
3900:
3901: --Used inv_organization_info_v instead of org_organization_definitions to fix the Perf Bug #4919255
3902: CURSOR ahl_ship_from_orgs_csr(p_name IN VARCHAR2) IS
3903: SELECT org.organization_id
3904: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def
3905: WHERE org.organization_id = def.organization_id

Line 3904: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def

3900:
3901: --Used inv_organization_info_v instead of org_organization_definitions to fix the Perf Bug #4919255
3902: CURSOR ahl_ship_from_orgs_csr(p_name IN VARCHAR2) IS
3903: SELECT org.organization_id
3904: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def
3905: WHERE org.organization_id = def.organization_id
3906: -- Changed by jaramana on Sep 9, 2005 for MOAC Uptake
3907: -- AND def.operating_unit = FND_PROFILE.VALUE('DEFAULT_ORG_ID')
3908: AND def.operating_unit = MO_GLOBAL.get_current_org_id()