DBA Data[Home] [Help]

APPS.WMS_RULE_PVT dependencies on BOM_STANDARD_OPERATIONS

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)