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.

[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on WMS_SELECTION_CRITERIA_TXN

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

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

Line 680: l_rec_wsct WMS_SELECTION_CRITERIA_TXN%ROWTYPE;

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

Line 684: l_sequence_number wms_selection_criteria_txn.sequence_number%type;

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

Line 685: l_return_type_code wms_selection_criteria_txn.return_type_code%type;

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

Line 686: l_return_type_id wms_selection_criteria_txn.return_type_id%type;

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

Line 687: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;

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

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

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

Line 689: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;

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

Line 690: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;

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

Line 691: l_customer_id wms_selection_criteria_txn.customer_id%type;

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

Line 692: l_freight_code wms_selection_criteria_txn.freight_code%type;

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

Line 693: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;

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

Line 694: l_item_type wms_selection_criteria_txn.item_type%type;

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

Line 695: l_order_type_id wms_selection_criteria_txn.order_type_id%type;

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

Line 696: l_vendor_id wms_selection_criteria_txn.vendor_id%type;

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

Line 697: l_project_id wms_selection_criteria_txn.project_id%type;

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

Line 698: l_task_id wms_selection_criteria_txn.task_id%type;

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

Line 699: l_user_id wms_selection_criteria_txn.user_id%type;

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

Line 700: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;

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

Line 701: l_reason_id wms_selection_criteria_txn.reason_id%type;

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

Line 702: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;

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

Line 703: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;

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

Line 704: l_uom_code wms_selection_criteria_txn.uom_code%type;

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

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

701: l_reason_id wms_selection_criteria_txn.reason_id%type;
702: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
703: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
704: l_uom_code wms_selection_criteria_txn.uom_code%type;
705: l_uom_class wms_selection_criteria_txn.uom_class%type default null;
706:
707: l_return_value BOOLEAN;
708:
709: --- Cursor for Strategy /Rule /Value Selection based on the current move order line

Line 713: from wms_selection_criteria_txn

709: --- Cursor for Strategy /Rule /Value Selection based on the current move order line
710: --
711: cursor cur_stg_selection is
712: select return_type_code, return_type_id, sequence_number
713: from wms_selection_criteria_txn
714: where from_organization_id = l_from_organization_id
715: and rule_type_code = p_type_code
716: and enabled_flag = 1
717: and nvl(from_subinventory_name, l_from_subinventory_name) = l_from_subinventory_name

Line 1067: l_rec_wsct WMS_SELECTION_CRITERIA_TXN%ROWTYPE;

1063: l_api_name constant VARCHAR2(30) := 'CG_MMTT_SEARCH';
1064:
1065: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
1066:
1067: l_rec_wsct WMS_SELECTION_CRITERIA_TXN%ROWTYPE;
1068: -- l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;
1069:
1070: TYPE rec_mmtt is RECORD (
1071: line_id mtl_material_transactions_temp.transaction_temp_id%TYPE,

Line 1092: l_sequence_number wms_selection_criteria_txn.sequence_number%type;

1088: );
1089:
1090: l_rec_mtrl rec_mmtt;
1091:
1092: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
1093: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
1094: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
1095: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
1096: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;

Line 1093: l_return_type_code wms_selection_criteria_txn.return_type_code%type;

1089:
1090: l_rec_mtrl rec_mmtt;
1091:
1092: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
1093: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
1094: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
1095: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
1096: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
1097: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;

Line 1094: l_return_type_id wms_selection_criteria_txn.return_type_id%type;

1090: l_rec_mtrl rec_mmtt;
1091:
1092: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
1093: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
1094: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
1095: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
1096: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
1097: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
1098: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;

Line 1095: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;

1091:
1092: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
1093: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
1094: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
1095: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
1096: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
1097: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
1098: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
1099: l_customer_id wms_selection_criteria_txn.customer_id%type;

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

1092: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
1093: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
1094: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
1095: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
1096: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
1097: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
1098: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
1099: l_customer_id wms_selection_criteria_txn.customer_id%type;
1100: l_freight_code wms_selection_criteria_txn.freight_code%type;

Line 1097: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;

1093: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
1094: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
1095: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
1096: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
1097: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
1098: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
1099: l_customer_id wms_selection_criteria_txn.customer_id%type;
1100: l_freight_code wms_selection_criteria_txn.freight_code%type;
1101: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;

Line 1098: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;

1094: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
1095: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
1096: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
1097: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
1098: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
1099: l_customer_id wms_selection_criteria_txn.customer_id%type;
1100: l_freight_code wms_selection_criteria_txn.freight_code%type;
1101: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
1102: l_item_type wms_selection_criteria_txn.item_type%type;

Line 1099: l_customer_id wms_selection_criteria_txn.customer_id%type;

1095: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
1096: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
1097: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
1098: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
1099: l_customer_id wms_selection_criteria_txn.customer_id%type;
1100: l_freight_code wms_selection_criteria_txn.freight_code%type;
1101: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
1102: l_item_type wms_selection_criteria_txn.item_type%type;
1103: l_order_type_id wms_selection_criteria_txn.order_type_id%type;

Line 1100: l_freight_code wms_selection_criteria_txn.freight_code%type;

1096: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type default null;
1097: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
1098: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
1099: l_customer_id wms_selection_criteria_txn.customer_id%type;
1100: l_freight_code wms_selection_criteria_txn.freight_code%type;
1101: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
1102: l_item_type wms_selection_criteria_txn.item_type%type;
1103: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
1104: l_vendor_id wms_selection_criteria_txn.vendor_id%type;

Line 1101: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;

1097: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
1098: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
1099: l_customer_id wms_selection_criteria_txn.customer_id%type;
1100: l_freight_code wms_selection_criteria_txn.freight_code%type;
1101: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
1102: l_item_type wms_selection_criteria_txn.item_type%type;
1103: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
1104: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
1105: l_project_id wms_selection_criteria_txn.project_id%type;

Line 1102: l_item_type wms_selection_criteria_txn.item_type%type;

1098: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
1099: l_customer_id wms_selection_criteria_txn.customer_id%type;
1100: l_freight_code wms_selection_criteria_txn.freight_code%type;
1101: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
1102: l_item_type wms_selection_criteria_txn.item_type%type;
1103: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
1104: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
1105: l_project_id wms_selection_criteria_txn.project_id%type;
1106: l_task_id wms_selection_criteria_txn.task_id%type;

Line 1103: l_order_type_id wms_selection_criteria_txn.order_type_id%type;

1099: l_customer_id wms_selection_criteria_txn.customer_id%type;
1100: l_freight_code wms_selection_criteria_txn.freight_code%type;
1101: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
1102: l_item_type wms_selection_criteria_txn.item_type%type;
1103: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
1104: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
1105: l_project_id wms_selection_criteria_txn.project_id%type;
1106: l_task_id wms_selection_criteria_txn.task_id%type;
1107: l_user_id wms_selection_criteria_txn.user_id%type;

Line 1104: l_vendor_id wms_selection_criteria_txn.vendor_id%type;

1100: l_freight_code wms_selection_criteria_txn.freight_code%type;
1101: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
1102: l_item_type wms_selection_criteria_txn.item_type%type;
1103: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
1104: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
1105: l_project_id wms_selection_criteria_txn.project_id%type;
1106: l_task_id wms_selection_criteria_txn.task_id%type;
1107: l_user_id wms_selection_criteria_txn.user_id%type;
1108: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;

Line 1105: l_project_id wms_selection_criteria_txn.project_id%type;

1101: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
1102: l_item_type wms_selection_criteria_txn.item_type%type;
1103: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
1104: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
1105: l_project_id wms_selection_criteria_txn.project_id%type;
1106: l_task_id wms_selection_criteria_txn.task_id%type;
1107: l_user_id wms_selection_criteria_txn.user_id%type;
1108: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
1109: l_reason_id wms_selection_criteria_txn.reason_id%type;

Line 1106: l_task_id wms_selection_criteria_txn.task_id%type;

1102: l_item_type wms_selection_criteria_txn.item_type%type;
1103: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
1104: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
1105: l_project_id wms_selection_criteria_txn.project_id%type;
1106: l_task_id wms_selection_criteria_txn.task_id%type;
1107: l_user_id wms_selection_criteria_txn.user_id%type;
1108: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
1109: l_reason_id wms_selection_criteria_txn.reason_id%type;
1110: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;

Line 1107: l_user_id wms_selection_criteria_txn.user_id%type;

1103: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
1104: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
1105: l_project_id wms_selection_criteria_txn.project_id%type;
1106: l_task_id wms_selection_criteria_txn.task_id%type;
1107: l_user_id wms_selection_criteria_txn.user_id%type;
1108: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
1109: l_reason_id wms_selection_criteria_txn.reason_id%type;
1110: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
1111: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;

Line 1108: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;

1104: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
1105: l_project_id wms_selection_criteria_txn.project_id%type;
1106: l_task_id wms_selection_criteria_txn.task_id%type;
1107: l_user_id wms_selection_criteria_txn.user_id%type;
1108: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
1109: l_reason_id wms_selection_criteria_txn.reason_id%type;
1110: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
1111: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
1112: l_uom_code wms_selection_criteria_txn.uom_code%type;

Line 1109: l_reason_id wms_selection_criteria_txn.reason_id%type;

1105: l_project_id wms_selection_criteria_txn.project_id%type;
1106: l_task_id wms_selection_criteria_txn.task_id%type;
1107: l_user_id wms_selection_criteria_txn.user_id%type;
1108: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
1109: l_reason_id wms_selection_criteria_txn.reason_id%type;
1110: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
1111: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
1112: l_uom_code wms_selection_criteria_txn.uom_code%type;
1113: l_uom_class wms_selection_criteria_txn.uom_class%type default null;

Line 1110: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;

1106: l_task_id wms_selection_criteria_txn.task_id%type;
1107: l_user_id wms_selection_criteria_txn.user_id%type;
1108: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
1109: l_reason_id wms_selection_criteria_txn.reason_id%type;
1110: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
1111: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
1112: l_uom_code wms_selection_criteria_txn.uom_code%type;
1113: l_uom_class wms_selection_criteria_txn.uom_class%type default null;
1114:

Line 1111: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;

1107: l_user_id wms_selection_criteria_txn.user_id%type;
1108: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
1109: l_reason_id wms_selection_criteria_txn.reason_id%type;
1110: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
1111: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
1112: l_uom_code wms_selection_criteria_txn.uom_code%type;
1113: l_uom_class wms_selection_criteria_txn.uom_class%type default null;
1114:
1115: --- Cursor for Strategy /Rule /Value Selection based on the current move order line

Line 1112: l_uom_code wms_selection_criteria_txn.uom_code%type;

1108: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
1109: l_reason_id wms_selection_criteria_txn.reason_id%type;
1110: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
1111: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
1112: l_uom_code wms_selection_criteria_txn.uom_code%type;
1113: l_uom_class wms_selection_criteria_txn.uom_class%type default null;
1114:
1115: --- Cursor for Strategy /Rule /Value Selection based on the current move order line
1116: --

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

1109: l_reason_id wms_selection_criteria_txn.reason_id%type;
1110: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
1111: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
1112: l_uom_code wms_selection_criteria_txn.uom_code%type;
1113: l_uom_class wms_selection_criteria_txn.uom_class%type default null;
1114:
1115: --- Cursor for Strategy /Rule /Value Selection based on the current move order line
1116: --
1117: cursor cur_stg_selection is

Line 1119: from wms_selection_criteria_txn

1115: --- Cursor for Strategy /Rule /Value Selection based on the current move order line
1116: --
1117: cursor cur_stg_selection is
1118: select return_type_code, return_type_id, sequence_number
1119: from wms_selection_criteria_txn
1120: where from_organization_id = l_from_organization_id
1121: and rule_type_code = p_type_code
1122: and enabled_flag = 1
1123: and nvl(from_subinventory_name, l_from_subinventory_name) = l_from_subinventory_name

Line 1815: l_sequence_number wms_selection_criteria_txn.sequence_number%type;

1811: l_api_version CONSTANT NUMBER := 1.0;
1812: l_api_name constant VARCHAR2(30) := 'cross_dock_search';
1813: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
1814:
1815: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
1816: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
1817: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
1818: l_msg_count NUMBER;
1819: l_msg_data VARCHAR2(2000);

Line 1816: l_return_type_code wms_selection_criteria_txn.return_type_code%type;

1812: l_api_name constant VARCHAR2(30) := 'cross_dock_search';
1813: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
1814:
1815: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
1816: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
1817: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
1818: l_msg_count NUMBER;
1819: l_msg_data VARCHAR2(2000);
1820:

Line 1817: l_return_type_id wms_selection_criteria_txn.return_type_id%type;

1813: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
1814:
1815: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
1816: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
1817: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
1818: l_msg_count NUMBER;
1819: l_msg_data VARCHAR2(2000);
1820:
1821: CURSOR cur_crossdock_value_selection IS

Line 1823: FROM wms_selection_criteria_txn

1819: l_msg_data VARCHAR2(2000);
1820:
1821: CURSOR cur_crossdock_value_selection IS
1822: SELECT return_type_code, return_type_id, sequence_number
1823: FROM wms_selection_criteria_txn
1824: WHERE from_organization_id = p_organization_id
1825: AND rule_type_code = p_rule_type_code
1826: AND enabled_flag = 1
1827: AND NVL(customer_id, NVL(p_customer_id, -9)) = NVL(p_customer_id, -9)