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.WMS_STRATEGY_PVT dependencies on WMS_DB_OBJECTS

Line 914: l_db_object_id WMS_DB_OBJECTS.DB_OBJECT_ID%type;

910: -- other variables
911: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%type;
912: l_object_id WMS_OBJECTS_B.OBJECT_ID%type;
913: l_strat_asgmt_db_object_id WMS_OBJECTS_B.STRAT_ASGMT_DB_OBJECT_ID%type;
914: l_db_object_id WMS_DB_OBJECTS.DB_OBJECT_ID%type;
915: l_table_name WMS_DB_OBJECTS.TABLE_NAME%type;
916: l_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%type;
917: l_parent_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%type;
918: l_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;

Line 915: l_table_name WMS_DB_OBJECTS.TABLE_NAME%type;

911: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%type;
912: l_object_id WMS_OBJECTS_B.OBJECT_ID%type;
913: l_strat_asgmt_db_object_id WMS_OBJECTS_B.STRAT_ASGMT_DB_OBJECT_ID%type;
914: l_db_object_id WMS_DB_OBJECTS.DB_OBJECT_ID%type;
915: l_table_name WMS_DB_OBJECTS.TABLE_NAME%type;
916: l_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%type;
917: l_parent_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%type;
918: l_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
919: l_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;

Line 916: l_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%type;

912: l_object_id WMS_OBJECTS_B.OBJECT_ID%type;
913: l_strat_asgmt_db_object_id WMS_OBJECTS_B.STRAT_ASGMT_DB_OBJECT_ID%type;
914: l_db_object_id WMS_DB_OBJECTS.DB_OBJECT_ID%type;
915: l_table_name WMS_DB_OBJECTS.TABLE_NAME%type;
916: l_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%type;
917: l_parent_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%type;
918: l_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
919: l_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
920: l_expression WMS_PARAMETERS_B.EXPRESSION%type;

Line 917: l_parent_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%type;

913: l_strat_asgmt_db_object_id WMS_OBJECTS_B.STRAT_ASGMT_DB_OBJECT_ID%type;
914: l_db_object_id WMS_DB_OBJECTS.DB_OBJECT_ID%type;
915: l_table_name WMS_DB_OBJECTS.TABLE_NAME%type;
916: l_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%type;
917: l_parent_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%type;
918: l_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
919: l_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
920: l_expression WMS_PARAMETERS_B.EXPRESSION%type;
921: l_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;

Line 940: l_table_alias_left WMS_DB_OBJECTS.TABLE_ALIAS%type;

936: ---
937: --
938: --Bug # 2465807 / Grao - To handle SO for Cost Group Search Order (Item Type)
939:
940: l_table_alias_left WMS_DB_OBJECTS.TABLE_ALIAS%type;
941:
942: -- cursor for getting actual inventory org to search for strategy
943: cursor input is
944: select decode(p_type_code, 1, mpsmttv.TO_ORGANIZATION_ID,

Line 977: from WMS_DB_OBJECTS mpdo

973: cursor objects is
974: select mpdo.DB_OBJECT_ID
975: ,mpdo.TABLE_NAME
976: ,mpdo.TABLE_ALIAS
977: from WMS_DB_OBJECTS mpdo
978: where mpdo.db_object_id IN
979: (SELECT mpdo.db_object_id
980: FROM wms_db_objects mpdo
981: WHERE mpdo.db_object_id = l_strat_asgmt_db_object_id

Line 980: FROM wms_db_objects mpdo

976: ,mpdo.TABLE_ALIAS
977: from WMS_DB_OBJECTS mpdo
978: where mpdo.db_object_id IN
979: (SELECT mpdo.db_object_id
980: FROM wms_db_objects mpdo
981: WHERE mpdo.db_object_id = l_strat_asgmt_db_object_id
982: UNION
983: SELECT mpdop.parent_db_object_id
984: FROM wms_db_objects_parents mpdop

Line 984: FROM wms_db_objects_parents mpdop

980: FROM wms_db_objects mpdo
981: WHERE mpdo.db_object_id = l_strat_asgmt_db_object_id
982: UNION
983: SELECT mpdop.parent_db_object_id
984: FROM wms_db_objects_parents mpdop
985: WHERE mpdop.type_code = l_search_type_code
986: Connect by mpdop.DB_OBJECT_ID = prior mpdop.PARENT_DB_OBJECT_ID
987: Start with mpdop.DB_OBJECT_ID = l_strat_asgmt_db_object_id AND
988: mpdop.type_code = l_search_type_code );

Line 1005: from WMS_DB_OBJECTS mpdop

1001: ,mppp.COLUMN_NAME
1002: ,mppp.EXPRESSION
1003: ,mppp.DATA_TYPE_CODE
1004: ,mpdop.TABLE_ALIAS -- alias n.a. for multi object based parameters
1005: from WMS_DB_OBJECTS mpdop
1006: ,WMS_DB_OBJECTS mpdop1 -- added for CG
1007: ,WMS_PARAMETERS_B mppp
1008: ,WMS_PARAMETERS_B mpp
1009: ,WMS_DB_OBJECT_JOINS mpdoj

Line 1006: ,WMS_DB_OBJECTS mpdop1 -- added for CG

1002: ,mppp.EXPRESSION
1003: ,mppp.DATA_TYPE_CODE
1004: ,mpdop.TABLE_ALIAS -- alias n.a. for multi object based parameters
1005: from WMS_DB_OBJECTS mpdop
1006: ,WMS_DB_OBJECTS mpdop1 -- added for CG
1007: ,WMS_PARAMETERS_B mppp
1008: ,WMS_PARAMETERS_B mpp
1009: ,WMS_DB_OBJECT_JOINS mpdoj
1010: where mpdoj.DB_OBJECT_ID = l_db_object_id