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 784: -- Replaced org_organization_definitions with inv_organization_info_v which

780: END IF;
781:
782: BEGIN
783: -- SQL Performance ID 14882612
784: -- Replaced org_organization_definitions with inv_organization_info_v which
785: -- includes the validation that the organization is inventory enabled.
786: -- Please see bug 3742393 for details.
787: -- The table FND_PRODUCT_GROUPs (in inv_organization_info_v) always has one row and hence
788: -- FTS on this table can be ignored.

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

783: -- SQL Performance ID 14882612
784: -- Replaced org_organization_definitions with inv_organization_info_v which
785: -- includes the validation that the organization is inventory enabled.
786: -- Please see bug 3742393 for details.
787: -- The table FND_PRODUCT_GROUPs (in inv_organization_info_v) always has one row and hence
788: -- FTS on this table can be ignored.
789:
790: SELECT msi.stock_enabled_flag ,revision_qty_control_code
791: INTO l_stock_enabled_flag, l_revision_control_code

Line 792: FROM mtl_system_items msi,inv_organization_info_v org

788: -- FTS on this table can be ignored.
789:
790: SELECT msi.stock_enabled_flag ,revision_qty_control_code
791: INTO l_stock_enabled_flag, l_revision_control_code
792: FROM mtl_system_items msi,inv_organization_info_v org
793: WHERE msi.inventory_item_id = p_drop_ship_line_rec.inventory_item_id
794: AND org.organization_id = msi.organization_id
795: AND org.organization_id = p_drop_ship_line_rec.ship_from_org_id;
796:

Line 877: -- Replaced org_organization_definitions with inv_organization_info_v which

873: l_prof_value :=fnd_profile.value('ONT_POPULATE_BUYER'); --Fix for bug#2172019
874:
875: IF PO_CODE_RELEASE_GRP.Current_Release >= PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J THEN
876: -- SQL Performance ID 14882656
877: -- Replaced org_organization_definitions with inv_organization_info_v which
878: -- includes the validation that the organization is inventory enabled.
879: -- Please see bug 3742393 for details.
880: -- The table FND_PRODUCT_GROUPs (in inv_organization_info_v) always has one row and hence
881: -- FTS on this table can be ignored.

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

876: -- SQL Performance ID 14882656
877: -- Replaced org_organization_definitions with inv_organization_info_v which
878: -- includes the validation that the organization is inventory enabled.
879: -- Please see bug 3742393 for details.
880: -- The table FND_PRODUCT_GROUPs (in inv_organization_info_v) always has one row and hence
881: -- FTS on this table can be ignored.
882:
883: SELECT operating_unit
884: INTO l_ou_org_id

Line 885: FROM inv_organization_info_v

881: -- FTS on this table can be ignored.
882:
883: SELECT operating_unit
884: INTO l_ou_org_id
885: FROM inv_organization_info_v
886: WHERE organization_id = p_drop_ship_line_rec.ship_from_org_id;
887:
888: END IF;
889: