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_RULE_PVT dependencies on WMS_RULES_B

Line 995: wms_rules_b wrb,

991: INTO l_serial_object_used
992: FROM wms_selection_criteria_txn wsc,
993: wms_strategies_b wsb,
994: wms_strategy_members wsm,
995: wms_rules_b wrb,
996: wms_restrictions r,
997: wms_sort_criteria s,
998: wms_rule_consistencies c,
999: wms_parameters_b p

Line 1954: FROM wms_db_objects wdo, wms_parameters_b wpb, wms_rules_b wrb

1950: , wpb.column_name
1951: , wpb.expression
1952: , wpb.data_type_code
1953: , wdo.table_alias -- alias n.a. for multi object based parameters
1954: FROM wms_db_objects wdo, wms_parameters_b wpb, wms_rules_b wrb
1955: WHERE wrb.rule_id = p_rule_id
1956: AND wpb.parameter_id = wrb.qty_function_parameter_id
1957: AND wdo.db_object_id(+) = wpb.db_object_id;
1958:

Line 6470: -- Rule record has to exist in WMS_RULES_B uniquely

6466: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
6467: -- and parameters p_transaction_temp_id and p_type_code
6468: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and
6469: -- WMS_TRANSACTIONS_TEMP, respectively );
6470: -- Rule record has to exist in WMS_RULES_B uniquely
6471: -- identified by parameter p_rule_id;
6472: -- Package WMS_RULE_(RULEID) must exist;
6473: -- If picking, quantity tree has to exist, created through
6474: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified

Line 6747: FROM wms_rules_b

6743: -- works.
6744: CURSOR c_allocation_mode IS
6745: SELECT allocation_mode_id
6746: , qty_function_parameter_id
6747: FROM wms_rules_b
6748: WHERE rule_id = l_rule_id;
6749:
6750: --cursor used to determine if rule has any consistency requirements
6751: CURSOR l_consist IS

Line 12155: -- Pre-reqs : one record in WMS_RULES_B uniquely identified by parameter

12151: -- API name : CheckSyntax
12152: -- Type : Private
12153: -- Function : This wrapper on Generate_Rule_Package is
12154: -- called from the WMS_RULES form
12155: -- Pre-reqs : one record in WMS_RULES_B uniquely identified by parameter
12156: -- p_rule_id
12157: -- Input Parameters :
12158: -- p_api_version Standard Input Parameter
12159: -- p_init_msg_list Standard Input Parameter

Line 12549: l_type_code wms_rules_b.type_code%TYPE;

12545: l_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
12546: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
12547: --
12548: -- other variables
12549: l_type_code wms_rules_b.type_code%TYPE;
12550: l_package_name VARCHAR2(128);
12551: l_pack_sql VARCHAR2(32000);
12552: l_pack_body_sql VARCHAR2(32000);
12553: --

Line 12564: FROM wms_rules_b mpr

12560: -- cursor for validation of input parameters and pre-requisites
12561: CURSOR rule IS
12562: SELECT type_code
12563: , allocation_mode_id
12564: FROM wms_rules_b mpr
12565: WHERE mpr.rule_id = p_rule_id;
12566: --
12567: BEGIN
12568: --

Line 13802: WHERE EXISTS (SELECT 1 FROM wms_rules_b rules

13798: l_count := 0;
13799: BEGIN
13800: SELECT 1 INTO l_count
13801: FROM dual
13802: WHERE EXISTS (SELECT 1 FROM wms_rules_b rules
13803: WHERE rules.type_code = 7
13804: AND rules.enabled_flag = 'Y'
13805: AND (organization_id = -1
13806: OR organization_id IN (SELECT mmtt.organization_id

Line 13929: FROM wms_rules_b rules, wms_op_plans_b wop, mtl_material_transactions_temp mmtt

13925: SELECT rules.rule_id
13926: , mmtt.organization_id
13927: , mmtt.wms_task_type
13928: , rules.type_hdr_id
13929: FROM wms_rules_b rules, wms_op_plans_b wop, mtl_material_transactions_temp mmtt
13930: WHERE rules.type_code = 7
13931: AND rules.enabled_flag = 'Y'
13932: AND rules.type_hdr_id = wop.operation_plan_id
13933: AND wop.system_task_type = NVL(mmtt.wms_task_type, wop.system_task_type)

Line 14150: WHERE EXISTS (SELECT 1 FROM wms_rules_b rules

14146: l_count := 0;
14147: BEGIN
14148: SELECT 1 INTO l_count
14149: FROM dual
14150: WHERE EXISTS (SELECT 1 FROM wms_rules_b rules
14151: WHERE rules.type_code = 3
14152: AND rules.enabled_flag = 'Y'
14153: AND (organization_id = -1
14154: OR organization_id IN (SELECT mmtt.organization_id

Line 14282: FROM wms_rules_b rules, bom_standard_operations bso , mtl_material_transactions_temp mmtt

14278: SELECT rules.rule_id
14279: , rules.type_hdr_id /* Added this Column */
14280: , mmtt.organization_id
14281: , mmtt.wms_task_type
14282: FROM wms_rules_b rules, bom_standard_operations bso , mtl_material_transactions_temp mmtt
14283: WHERE rules.type_code = 3
14284: AND rules.enabled_flag = 'Y'
14285: AND rules.type_hdr_id = bso.standard_operation_id
14286: AND bso.wms_task_type = NVL(mmtt.wms_task_type, bso.wms_task_type)

Line 14294: FROM wms_rules_b rules, bom_standard_operations bso

14290: ORDER BY rules.rule_weight DESC, rules.creation_date;
14291:
14292: /*CURSOR c_rules_new IS
14293: SELECT rules.rule_id , rules.type_hdr_id
14294: FROM wms_rules_b rules, bom_standard_operations bso
14295: WHERE rules.type_code = 3
14296: AND rules.enabled_flag = 'Y'
14297: AND rules.type_hdr_id = bso.standard_operation_id
14298: AND bso.wms_task_type = NVL(p_wms_task_type, bso.wms_task_type)

Line 14411: FROM wms_rules_b

14407: WHERE mmtt.transaction_temp_id = p_task_id;
14408: /*
14409: UPDATE mtl_material_transactions_temp mmtt
14410: SET mmtt.standard_operation_id = (SELECT type_hdr_id
14411: FROM wms_rules_b
14412: WHERE rule_id = l_rule_id)
14413: WHERE mmtt.transaction_temp_id = p_task_id
14414: */
14415:

Line 14557: UPDATE wms_rules_b

14553:
14554: PROCEDURE calcruleweight(p_rule_id NUMBER) IS
14555: BEGIN
14556:
14557: UPDATE wms_rules_b
14558: SET rule_weight = (SELECT 100 * COUNT(parameter_id)
14559: FROM (SELECT DISTINCT rules.rule_id
14560: , par.parameter_id
14561: FROM wms_rules_b rules, wms_restrictions rest, wms_parameters_b par

Line 14561: FROM wms_rules_b rules, wms_restrictions rest, wms_parameters_b par

14557: UPDATE wms_rules_b
14558: SET rule_weight = (SELECT 100 * COUNT(parameter_id)
14559: FROM (SELECT DISTINCT rules.rule_id
14560: , par.parameter_id
14561: FROM wms_rules_b rules, wms_restrictions rest, wms_parameters_b par
14562: WHERE rules.rule_id = p_rule_id
14563: AND rules.rule_id = rest.rule_id(+)
14564: AND rest.parameter_id = par.parameter_id(+)
14565: AND (NVL(par.use_for_tt_assn_flag, 'Y') = 'Y'

Line 14639: FROM wms_rules_b rules, wms_label_formats wl, wms_label_requests wlr

14635: , rules.rule_weight
14636: , rules.type_hdr_id
14637: , wl.label_format_name
14638: , wl.document_id
14639: FROM wms_rules_b rules, wms_label_formats wl, wms_label_requests wlr
14640: WHERE rules.type_code = 4
14641: AND rules.type_hdr_id = wl.label_format_id
14642: AND wl.label_format_id = NVL(wlr.label_format_id, wl.label_format_id)
14643: AND NVL(format_disable_date, SYSDATE + 1) > SYSDATE --Bug #3452076

Line 14678: FROM wms_rules_b rules, wms_label_formats wl, wms_label_requests wlr

14674: BEGIN
14675: SAVEPOINT assignlabelsp;
14676: ----
14677: SELECT count(rules.rule_id ) into ll_ctr
14678: FROM wms_rules_b rules, wms_label_formats wl, wms_label_requests wlr
14679: WHERE rules.type_code = 4
14680: AND rules.type_hdr_id = wl.label_format_id
14681: AND wl.label_format_id = NVL(wlr.label_format_id, wl.label_format_id)
14682: AND NVL(format_disable_date, SYSDATE + 1) > SYSDATE --Bug # 3452076

Line 14906: FROM wms_rules_b

14902: l_return_code NUMBER;
14903:
14904: CURSOR l_enabled_rules IS
14905: SELECT rule_id
14906: FROM wms_rules_b
14907: WHERE enabled_flag = 'Y'
14908: ORDER BY rule_id;
14909: BEGIN
14910: --fnd_file.put_names('genall.log', 'genall.out', '/home/jcearley/work/');

Line 15658: -- Rule record has to exist in WMS_RULES_B uniquely

15654: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
15655: -- and parameters p_transaction_temp_id and p_type_code
15656: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and
15657: -- WMS_TRANSACTIONS_TEMP, respectively );
15658: -- Rule record has to exist in WMS_RULES_B uniquely
15659: -- identified by parameter p_rule_id;
15660: -- Package WMS_RULE_(RULEID) must exist;
15661: -- If picking, quantity tree has to exist, created through
15662: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified

Line 15886: FROM wms_rules_b

15882: -- works.
15883: CURSOR c_allocation_mode IS
15884: SELECT allocation_mode_id
15885: , qty_function_parameter_id
15886: FROM wms_rules_b
15887: WHERE rule_id = l_rule_id;
15888:
15889: --cursor used to determine if rule has any consistency requirements
15890: CURSOR l_consist IS