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

Line 749: -- Replaced org_organization_definitions with inv_organization_info_v which

745: END IF;
746:
747: BEGIN
748: -- SQL Performance ID 14882612
749: -- Replaced org_organization_definitions with inv_organization_info_v which
750: -- includes the validation that the organization is inventory enabled.
751: -- Please see bug 3742393 for details.
752: -- The table FND_PRODUCT_GROUPs (in inv_organization_info_v) always has one row and hence
753: -- FTS on this table can be ignored.

Line 752: -- The table FND_PRODUCT_GROUPs (in inv_organization_info_v) always has one row and hence

748: -- SQL Performance ID 14882612
749: -- Replaced org_organization_definitions with inv_organization_info_v which
750: -- includes the validation that the organization is inventory enabled.
751: -- Please see bug 3742393 for details.
752: -- The table FND_PRODUCT_GROUPs (in inv_organization_info_v) always has one row and hence
753: -- FTS on this table can be ignored.
754:
755: SELECT msi.stock_enabled_flag ,revision_qty_control_code
756: INTO l_stock_enabled_flag, l_revision_control_code

Line 757: FROM mtl_system_items msi,inv_organization_info_v org

753: -- FTS on this table can be ignored.
754:
755: SELECT msi.stock_enabled_flag ,revision_qty_control_code
756: INTO l_stock_enabled_flag, l_revision_control_code
757: FROM mtl_system_items msi,inv_organization_info_v org
758: WHERE msi.inventory_item_id = p_drop_ship_line_rec.inventory_item_id
759: AND org.organization_id = msi.organization_id
760: AND org.organization_id = p_drop_ship_line_rec.ship_from_org_id;
761:

Line 842: -- Replaced org_organization_definitions with inv_organization_info_v which

838: l_prof_value :=fnd_profile.value('ONT_POPULATE_BUYER'); --Fix for bug#2172019
839:
840: IF PO_CODE_RELEASE_GRP.Current_Release >= PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J THEN
841: -- SQL Performance ID 14882656
842: -- Replaced org_organization_definitions with inv_organization_info_v which
843: -- includes the validation that the organization is inventory enabled.
844: -- Please see bug 3742393 for details.
845: -- The table FND_PRODUCT_GROUPs (in inv_organization_info_v) always has one row and hence
846: -- FTS on this table can be ignored.

Line 845: -- The table FND_PRODUCT_GROUPs (in inv_organization_info_v) always has one row and hence

841: -- SQL Performance ID 14882656
842: -- Replaced org_organization_definitions with inv_organization_info_v which
843: -- includes the validation that the organization is inventory enabled.
844: -- Please see bug 3742393 for details.
845: -- The table FND_PRODUCT_GROUPs (in inv_organization_info_v) always has one row and hence
846: -- FTS on this table can be ignored.
847:
848: SELECT operating_unit
849: INTO l_ou_org_id

Line 850: FROM inv_organization_info_v

846: -- FTS on this table can be ignored.
847:
848: SELECT operating_unit
849: INTO l_ou_org_id
850: FROM inv_organization_info_v
851: WHERE organization_id = p_drop_ship_line_rec.ship_from_org_id;
852:
853: END IF;
854: