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_RULES_WORKBENCH_PVT dependencies on WMS_SELECTION_CRITERIA_TXN

Line 98: ---- to be used in the view wms_selection_criteria_txn_v

94:
95: END log_procedure;
96:
97: ---- Function to get Return type name ( Strategy / Rule name )
98: ---- to be used in the view wms_selection_criteria_txn_v
99:
100: Function get_return_type_name(p_org_id IN NUMBER,
101: p_rule_type_code IN NUMBER,
102: p_return_type_code IN VARCHAR2,

Line 681: l_rec_wsct WMS_SELECTION_CRITERIA_TXN%ROWTYPE;

677:
678: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
679:
680:
681: l_rec_wsct WMS_SELECTION_CRITERIA_TXN%ROWTYPE;
682: l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;
683:
684:
685: l_sequence_number wms_selection_criteria_txn.sequence_number%type;

Line 685: l_sequence_number wms_selection_criteria_txn.sequence_number%type;

681: l_rec_wsct WMS_SELECTION_CRITERIA_TXN%ROWTYPE;
682: l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;
683:
684:
685: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
686: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
687: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
688: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
689: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;

Line 686: l_return_type_code wms_selection_criteria_txn.return_type_code%type;

682: l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;
683:
684:
685: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
686: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
687: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
688: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
689: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
690: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;

Line 687: l_return_type_id wms_selection_criteria_txn.return_type_id%type;

683:
684:
685: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
686: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
687: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
688: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
689: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
690: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
691: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;

Line 688: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;

684:
685: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
686: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
687: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
688: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
689: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
690: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
691: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
692: l_customer_id wms_selection_criteria_txn.customer_id%type;

Line 689: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;

685: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
686: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
687: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
688: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
689: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
690: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
691: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
692: l_customer_id wms_selection_criteria_txn.customer_id%type;
693: l_freight_code wms_selection_criteria_txn.freight_code%type;

Line 690: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;

686: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
687: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
688: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
689: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
690: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
691: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
692: l_customer_id wms_selection_criteria_txn.customer_id%type;
693: l_freight_code wms_selection_criteria_txn.freight_code%type;
694: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;

Line 691: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;

687: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
688: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
689: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
690: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
691: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
692: l_customer_id wms_selection_criteria_txn.customer_id%type;
693: l_freight_code wms_selection_criteria_txn.freight_code%type;
694: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
695: l_item_type wms_selection_criteria_txn.item_type%type;

Line 692: l_customer_id wms_selection_criteria_txn.customer_id%type;

688: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
689: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
690: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
691: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
692: l_customer_id wms_selection_criteria_txn.customer_id%type;
693: l_freight_code wms_selection_criteria_txn.freight_code%type;
694: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
695: l_item_type wms_selection_criteria_txn.item_type%type;
696: l_order_type_id wms_selection_criteria_txn.order_type_id%type;

Line 693: l_freight_code wms_selection_criteria_txn.freight_code%type;

689: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
690: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
691: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
692: l_customer_id wms_selection_criteria_txn.customer_id%type;
693: l_freight_code wms_selection_criteria_txn.freight_code%type;
694: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
695: l_item_type wms_selection_criteria_txn.item_type%type;
696: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
697: l_vendor_id wms_selection_criteria_txn.vendor_id%type;

Line 694: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;

690: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
691: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
692: l_customer_id wms_selection_criteria_txn.customer_id%type;
693: l_freight_code wms_selection_criteria_txn.freight_code%type;
694: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
695: l_item_type wms_selection_criteria_txn.item_type%type;
696: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
697: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
698: l_project_id wms_selection_criteria_txn.project_id%type;

Line 695: l_item_type wms_selection_criteria_txn.item_type%type;

691: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
692: l_customer_id wms_selection_criteria_txn.customer_id%type;
693: l_freight_code wms_selection_criteria_txn.freight_code%type;
694: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
695: l_item_type wms_selection_criteria_txn.item_type%type;
696: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
697: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
698: l_project_id wms_selection_criteria_txn.project_id%type;
699: l_task_id wms_selection_criteria_txn.task_id%type;

Line 696: l_order_type_id wms_selection_criteria_txn.order_type_id%type;

692: l_customer_id wms_selection_criteria_txn.customer_id%type;
693: l_freight_code wms_selection_criteria_txn.freight_code%type;
694: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
695: l_item_type wms_selection_criteria_txn.item_type%type;
696: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
697: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
698: l_project_id wms_selection_criteria_txn.project_id%type;
699: l_task_id wms_selection_criteria_txn.task_id%type;
700: l_user_id wms_selection_criteria_txn.user_id%type;

Line 697: l_vendor_id wms_selection_criteria_txn.vendor_id%type;

693: l_freight_code wms_selection_criteria_txn.freight_code%type;
694: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
695: l_item_type wms_selection_criteria_txn.item_type%type;
696: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
697: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
698: l_project_id wms_selection_criteria_txn.project_id%type;
699: l_task_id wms_selection_criteria_txn.task_id%type;
700: l_user_id wms_selection_criteria_txn.user_id%type;
701: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;

Line 698: l_project_id wms_selection_criteria_txn.project_id%type;

694: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
695: l_item_type wms_selection_criteria_txn.item_type%type;
696: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
697: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
698: l_project_id wms_selection_criteria_txn.project_id%type;
699: l_task_id wms_selection_criteria_txn.task_id%type;
700: l_user_id wms_selection_criteria_txn.user_id%type;
701: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
702: l_reason_id wms_selection_criteria_txn.reason_id%type;

Line 699: l_task_id wms_selection_criteria_txn.task_id%type;

695: l_item_type wms_selection_criteria_txn.item_type%type;
696: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
697: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
698: l_project_id wms_selection_criteria_txn.project_id%type;
699: l_task_id wms_selection_criteria_txn.task_id%type;
700: l_user_id wms_selection_criteria_txn.user_id%type;
701: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
702: l_reason_id wms_selection_criteria_txn.reason_id%type;
703: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;

Line 700: l_user_id wms_selection_criteria_txn.user_id%type;

696: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
697: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
698: l_project_id wms_selection_criteria_txn.project_id%type;
699: l_task_id wms_selection_criteria_txn.task_id%type;
700: l_user_id wms_selection_criteria_txn.user_id%type;
701: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
702: l_reason_id wms_selection_criteria_txn.reason_id%type;
703: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
704: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;

Line 701: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;

697: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
698: l_project_id wms_selection_criteria_txn.project_id%type;
699: l_task_id wms_selection_criteria_txn.task_id%type;
700: l_user_id wms_selection_criteria_txn.user_id%type;
701: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
702: l_reason_id wms_selection_criteria_txn.reason_id%type;
703: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
704: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
705: l_uom_code wms_selection_criteria_txn.uom_code%type;

Line 702: l_reason_id wms_selection_criteria_txn.reason_id%type;

698: l_project_id wms_selection_criteria_txn.project_id%type;
699: l_task_id wms_selection_criteria_txn.task_id%type;
700: l_user_id wms_selection_criteria_txn.user_id%type;
701: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
702: l_reason_id wms_selection_criteria_txn.reason_id%type;
703: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
704: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
705: l_uom_code wms_selection_criteria_txn.uom_code%type;
706: l_uom_class wms_selection_criteria_txn.uom_class%type default null;

Line 703: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;

699: l_task_id wms_selection_criteria_txn.task_id%type;
700: l_user_id wms_selection_criteria_txn.user_id%type;
701: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
702: l_reason_id wms_selection_criteria_txn.reason_id%type;
703: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
704: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
705: l_uom_code wms_selection_criteria_txn.uom_code%type;
706: l_uom_class wms_selection_criteria_txn.uom_class%type default null;
707:

Line 704: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;

700: l_user_id wms_selection_criteria_txn.user_id%type;
701: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
702: l_reason_id wms_selection_criteria_txn.reason_id%type;
703: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
704: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
705: l_uom_code wms_selection_criteria_txn.uom_code%type;
706: l_uom_class wms_selection_criteria_txn.uom_class%type default null;
707:
708: l_return_value BOOLEAN;

Line 705: l_uom_code wms_selection_criteria_txn.uom_code%type;

701: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
702: l_reason_id wms_selection_criteria_txn.reason_id%type;
703: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
704: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
705: l_uom_code wms_selection_criteria_txn.uom_code%type;
706: l_uom_class wms_selection_criteria_txn.uom_class%type default null;
707:
708: l_return_value BOOLEAN;
709:

Line 706: l_uom_class wms_selection_criteria_txn.uom_class%type default null;

702: l_reason_id wms_selection_criteria_txn.reason_id%type;
703: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
704: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
705: l_uom_code wms_selection_criteria_txn.uom_code%type;
706: l_uom_class wms_selection_criteria_txn.uom_class%type default null;
707:
708: l_return_value BOOLEAN;
709:
710: --8809951 start

Line 711: l_category_id wms_selection_criteria_txn.category_id%type;

707:
708: l_return_value BOOLEAN;
709:
710: --8809951 start
711: l_category_id wms_selection_criteria_txn.category_id%type;
712: l_category_set_id wms_selection_criteria_txn.category_set_id%type;
713: l_assignment_group_id wms_selection_criteria_txn.assignment_group_id%type;
714: l_abc_class_id wms_selection_criteria_txn.abc_class_id%type;
715: TYPE mtrl_line_tabtype IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 712: l_category_set_id wms_selection_criteria_txn.category_set_id%type;

708: l_return_value BOOLEAN;
709:
710: --8809951 start
711: l_category_id wms_selection_criteria_txn.category_id%type;
712: l_category_set_id wms_selection_criteria_txn.category_set_id%type;
713: l_assignment_group_id wms_selection_criteria_txn.assignment_group_id%type;
714: l_abc_class_id wms_selection_criteria_txn.abc_class_id%type;
715: TYPE mtrl_line_tabtype IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
716: mtrl_line_tab mtrl_line_tabtype;

Line 713: l_assignment_group_id wms_selection_criteria_txn.assignment_group_id%type;

709:
710: --8809951 start
711: l_category_id wms_selection_criteria_txn.category_id%type;
712: l_category_set_id wms_selection_criteria_txn.category_set_id%type;
713: l_assignment_group_id wms_selection_criteria_txn.assignment_group_id%type;
714: l_abc_class_id wms_selection_criteria_txn.abc_class_id%type;
715: TYPE mtrl_line_tabtype IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
716: mtrl_line_tab mtrl_line_tabtype;
717:

Line 714: l_abc_class_id wms_selection_criteria_txn.abc_class_id%type;

710: --8809951 start
711: l_category_id wms_selection_criteria_txn.category_id%type;
712: l_category_set_id wms_selection_criteria_txn.category_set_id%type;
713: l_assignment_group_id wms_selection_criteria_txn.assignment_group_id%type;
714: l_abc_class_id wms_selection_criteria_txn.abc_class_id%type;
715: TYPE mtrl_line_tabtype IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
716: mtrl_line_tab mtrl_line_tabtype;
717:
718: /*The sub query is to filter out the eligible records with the constant values that we have so that the

Line 819: from wms_selection_criteria_txn

815: , category_id
816: , category_set_id
817: , assignment_group_id
818: , abc_class_id
819: from wms_selection_criteria_txn
820: where from_organization_id = l_from_organization_id
821: and rule_type_code = p_type_code
822: and enabled_flag = 1
823: and nvl(from_subinventory_name, l_from_subinventory_name) = l_from_subinventory_name

Line 1263: l_rec_wsct WMS_SELECTION_CRITERIA_TXN%ROWTYPE;

1259: l_api_name constant VARCHAR2(30) := 'CG_MMTT_SEARCH';
1260:
1261: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
1262:
1263: l_rec_wsct WMS_SELECTION_CRITERIA_TXN%ROWTYPE;
1264: -- l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;
1265:
1266: TYPE rec_mmtt is RECORD (
1267: line_id mtl_material_transactions_temp.transaction_temp_id%TYPE,

Line 1288: l_sequence_number wms_selection_criteria_txn.sequence_number%type;

1284: );
1285:
1286: l_rec_mtrl rec_mmtt;
1287:
1288: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
1289: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
1290: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
1291: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
1292: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;

Line 1289: l_return_type_code wms_selection_criteria_txn.return_type_code%type;

1285:
1286: l_rec_mtrl rec_mmtt;
1287:
1288: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
1289: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
1290: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
1291: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
1292: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
1293: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;

Line 1290: l_return_type_id wms_selection_criteria_txn.return_type_id%type;

1286: l_rec_mtrl rec_mmtt;
1287:
1288: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
1289: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
1290: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
1291: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
1292: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
1293: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
1294: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;

Line 1291: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;

1287:
1288: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
1289: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
1290: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
1291: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
1292: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
1293: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
1294: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
1295: l_customer_id wms_selection_criteria_txn.customer_id%type;

Line 1292: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;

1288: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
1289: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
1290: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
1291: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
1292: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
1293: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
1294: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
1295: l_customer_id wms_selection_criteria_txn.customer_id%type;
1296: l_freight_code wms_selection_criteria_txn.freight_code%type;

Line 1293: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;

1289: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
1290: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
1291: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
1292: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
1293: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
1294: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
1295: l_customer_id wms_selection_criteria_txn.customer_id%type;
1296: l_freight_code wms_selection_criteria_txn.freight_code%type;
1297: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;

Line 1294: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;

1290: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
1291: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
1292: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
1293: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
1294: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
1295: l_customer_id wms_selection_criteria_txn.customer_id%type;
1296: l_freight_code wms_selection_criteria_txn.freight_code%type;
1297: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
1298: l_item_type wms_selection_criteria_txn.item_type%type;

Line 1295: l_customer_id wms_selection_criteria_txn.customer_id%type;

1291: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
1292: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
1293: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
1294: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
1295: l_customer_id wms_selection_criteria_txn.customer_id%type;
1296: l_freight_code wms_selection_criteria_txn.freight_code%type;
1297: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
1298: l_item_type wms_selection_criteria_txn.item_type%type;
1299: l_order_type_id wms_selection_criteria_txn.order_type_id%type;

Line 1296: l_freight_code wms_selection_criteria_txn.freight_code%type;

1292: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
1293: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
1294: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
1295: l_customer_id wms_selection_criteria_txn.customer_id%type;
1296: l_freight_code wms_selection_criteria_txn.freight_code%type;
1297: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
1298: l_item_type wms_selection_criteria_txn.item_type%type;
1299: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
1300: l_vendor_id wms_selection_criteria_txn.vendor_id%type;

Line 1297: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;

1293: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
1294: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
1295: l_customer_id wms_selection_criteria_txn.customer_id%type;
1296: l_freight_code wms_selection_criteria_txn.freight_code%type;
1297: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
1298: l_item_type wms_selection_criteria_txn.item_type%type;
1299: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
1300: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
1301: l_project_id wms_selection_criteria_txn.project_id%type;

Line 1298: l_item_type wms_selection_criteria_txn.item_type%type;

1294: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
1295: l_customer_id wms_selection_criteria_txn.customer_id%type;
1296: l_freight_code wms_selection_criteria_txn.freight_code%type;
1297: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
1298: l_item_type wms_selection_criteria_txn.item_type%type;
1299: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
1300: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
1301: l_project_id wms_selection_criteria_txn.project_id%type;
1302: l_task_id wms_selection_criteria_txn.task_id%type;

Line 1299: l_order_type_id wms_selection_criteria_txn.order_type_id%type;

1295: l_customer_id wms_selection_criteria_txn.customer_id%type;
1296: l_freight_code wms_selection_criteria_txn.freight_code%type;
1297: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
1298: l_item_type wms_selection_criteria_txn.item_type%type;
1299: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
1300: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
1301: l_project_id wms_selection_criteria_txn.project_id%type;
1302: l_task_id wms_selection_criteria_txn.task_id%type;
1303: l_user_id wms_selection_criteria_txn.user_id%type;

Line 1300: l_vendor_id wms_selection_criteria_txn.vendor_id%type;

1296: l_freight_code wms_selection_criteria_txn.freight_code%type;
1297: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
1298: l_item_type wms_selection_criteria_txn.item_type%type;
1299: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
1300: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
1301: l_project_id wms_selection_criteria_txn.project_id%type;
1302: l_task_id wms_selection_criteria_txn.task_id%type;
1303: l_user_id wms_selection_criteria_txn.user_id%type;
1304: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;

Line 1301: l_project_id wms_selection_criteria_txn.project_id%type;

1297: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
1298: l_item_type wms_selection_criteria_txn.item_type%type;
1299: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
1300: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
1301: l_project_id wms_selection_criteria_txn.project_id%type;
1302: l_task_id wms_selection_criteria_txn.task_id%type;
1303: l_user_id wms_selection_criteria_txn.user_id%type;
1304: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
1305: l_reason_id wms_selection_criteria_txn.reason_id%type;

Line 1302: l_task_id wms_selection_criteria_txn.task_id%type;

1298: l_item_type wms_selection_criteria_txn.item_type%type;
1299: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
1300: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
1301: l_project_id wms_selection_criteria_txn.project_id%type;
1302: l_task_id wms_selection_criteria_txn.task_id%type;
1303: l_user_id wms_selection_criteria_txn.user_id%type;
1304: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
1305: l_reason_id wms_selection_criteria_txn.reason_id%type;
1306: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;

Line 1303: l_user_id wms_selection_criteria_txn.user_id%type;

1299: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
1300: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
1301: l_project_id wms_selection_criteria_txn.project_id%type;
1302: l_task_id wms_selection_criteria_txn.task_id%type;
1303: l_user_id wms_selection_criteria_txn.user_id%type;
1304: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
1305: l_reason_id wms_selection_criteria_txn.reason_id%type;
1306: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
1307: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;

Line 1304: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;

1300: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
1301: l_project_id wms_selection_criteria_txn.project_id%type;
1302: l_task_id wms_selection_criteria_txn.task_id%type;
1303: l_user_id wms_selection_criteria_txn.user_id%type;
1304: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
1305: l_reason_id wms_selection_criteria_txn.reason_id%type;
1306: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
1307: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
1308: l_uom_code wms_selection_criteria_txn.uom_code%type;

Line 1305: l_reason_id wms_selection_criteria_txn.reason_id%type;

1301: l_project_id wms_selection_criteria_txn.project_id%type;
1302: l_task_id wms_selection_criteria_txn.task_id%type;
1303: l_user_id wms_selection_criteria_txn.user_id%type;
1304: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
1305: l_reason_id wms_selection_criteria_txn.reason_id%type;
1306: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
1307: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
1308: l_uom_code wms_selection_criteria_txn.uom_code%type;
1309: l_uom_class wms_selection_criteria_txn.uom_class%type default null;

Line 1306: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;

1302: l_task_id wms_selection_criteria_txn.task_id%type;
1303: l_user_id wms_selection_criteria_txn.user_id%type;
1304: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
1305: l_reason_id wms_selection_criteria_txn.reason_id%type;
1306: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
1307: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
1308: l_uom_code wms_selection_criteria_txn.uom_code%type;
1309: l_uom_class wms_selection_criteria_txn.uom_class%type default null;
1310:

Line 1307: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;

1303: l_user_id wms_selection_criteria_txn.user_id%type;
1304: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
1305: l_reason_id wms_selection_criteria_txn.reason_id%type;
1306: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
1307: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
1308: l_uom_code wms_selection_criteria_txn.uom_code%type;
1309: l_uom_class wms_selection_criteria_txn.uom_class%type default null;
1310:
1311: --- Cursor for Strategy /Rule /Value Selection based on the current move order line

Line 1308: l_uom_code wms_selection_criteria_txn.uom_code%type;

1304: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
1305: l_reason_id wms_selection_criteria_txn.reason_id%type;
1306: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
1307: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
1308: l_uom_code wms_selection_criteria_txn.uom_code%type;
1309: l_uom_class wms_selection_criteria_txn.uom_class%type default null;
1310:
1311: --- Cursor for Strategy /Rule /Value Selection based on the current move order line
1312: --

Line 1309: l_uom_class wms_selection_criteria_txn.uom_class%type default null;

1305: l_reason_id wms_selection_criteria_txn.reason_id%type;
1306: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
1307: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
1308: l_uom_code wms_selection_criteria_txn.uom_code%type;
1309: l_uom_class wms_selection_criteria_txn.uom_class%type default null;
1310:
1311: --- Cursor for Strategy /Rule /Value Selection based on the current move order line
1312: --
1313: cursor cur_stg_selection is

Line 1315: from wms_selection_criteria_txn

1311: --- Cursor for Strategy /Rule /Value Selection based on the current move order line
1312: --
1313: cursor cur_stg_selection is
1314: select return_type_code, return_type_id, sequence_number
1315: from wms_selection_criteria_txn
1316: where from_organization_id = l_from_organization_id
1317: and rule_type_code = p_type_code
1318: and enabled_flag = 1
1319: and nvl(from_subinventory_name, l_from_subinventory_name) = l_from_subinventory_name

Line 2114: l_sequence_number wms_selection_criteria_txn.sequence_number%type;

2110: l_api_version CONSTANT NUMBER := 1.0;
2111: l_api_name constant VARCHAR2(30) := 'cross_dock_search';
2112: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
2113:
2114: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
2115: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
2116: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
2117: l_msg_count NUMBER;
2118: l_msg_data VARCHAR2(2000);

Line 2115: l_return_type_code wms_selection_criteria_txn.return_type_code%type;

2111: l_api_name constant VARCHAR2(30) := 'cross_dock_search';
2112: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
2113:
2114: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
2115: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
2116: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
2117: l_msg_count NUMBER;
2118: l_msg_data VARCHAR2(2000);
2119:

Line 2116: l_return_type_id wms_selection_criteria_txn.return_type_id%type;

2112: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
2113:
2114: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
2115: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
2116: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
2117: l_msg_count NUMBER;
2118: l_msg_data VARCHAR2(2000);
2119:
2120: CURSOR cur_crossdock_value_selection IS

Line 2122: FROM wms_selection_criteria_txn

2118: l_msg_data VARCHAR2(2000);
2119:
2120: CURSOR cur_crossdock_value_selection IS
2121: SELECT return_type_code, return_type_id, sequence_number
2122: FROM wms_selection_criteria_txn
2123: WHERE from_organization_id = p_organization_id
2124: AND rule_type_code = p_rule_type_code
2125: AND enabled_flag = 1
2126: AND NVL(customer_id, NVL(p_customer_id, -9)) = NVL(p_customer_id, -9)