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 DUAL

Line 4279: l_dual_uom_ctl NUMBER;

4275: l_serial_index NUMBER;
4276: l_lot_divisible_flag VARCHAR2(1);
4277: l_lot_control_code NUMBER;
4278: l_to_locator_id NUMBER;
4279: l_dual_uom_ctl NUMBER;
4280: l_detailed_rsv_exist NUMBER;
4281: l_dummy_qty NUMBER;
4282:
4283: l_debug NUMBER;

Line 4289: , dual_uom_control

4285:
4286: CURSOR C_item_info IS
4287: SELECT lot_divisible_flag
4288: , lot_control_code
4289: , dual_uom_control
4290: FROM mtl_system_items
4291: WHERE organization_id = p_organization_id
4292: AND inventory_item_id = p_inventory_item_id;
4293:

Line 4316: , l_dual_uom_ctl

4312: Open C_item_info;
4313: Fetch C_item_info
4314: Into l_lot_divisible_flag
4315: , l_lot_control_code
4316: , l_dual_uom_ctl
4317: ;
4318: Close C_item_info;
4319: */
4320: -- [ Added the following code and commented the above item cursor

Line 4323: l_dual_uom_ctl := inv_cache.item_rec.dual_uom_control;

4319: */
4320: -- [ Added the following code and commented the above item cursor
4321: l_lot_divisible_flag := inv_cache.item_rec.lot_divisible_flag;
4322: l_lot_control_code := inv_cache.item_rec.lot_control_code;
4323: l_dual_uom_ctl := inv_cache.item_rec.dual_uom_control;
4324: -- ]
4325: /* lot specific conversion 3986955*/
4326: IF l_dual_uom_ctl > 1 and nvl(g_locs(p_record_id).lot_number,'-9999') <> '-9999' THEN
4327: /* bug 5441849, if detailed reservation exist, meaning that user has made the

Line 4326: IF l_dual_uom_ctl > 1 and nvl(g_locs(p_record_id).lot_number,'-9999') <> '-9999' THEN

4322: l_lot_control_code := inv_cache.item_rec.lot_control_code;
4323: l_dual_uom_ctl := inv_cache.item_rec.dual_uom_control;
4324: -- ]
4325: /* lot specific conversion 3986955*/
4326: IF l_dual_uom_ctl > 1 and nvl(g_locs(p_record_id).lot_number,'-9999') <> '-9999' THEN
4327: /* bug 5441849, if detailed reservation exist, meaning that user has made the
4328: * correct 2nd qty either by system defaults on the lot
4329: * or manually changed it with the appropriate value, this value on the reservation
4330: * should be carried over to the allocation

Line 4355: IF l_dual_uom_ctl = 1 THEN

4351: );
4352: End if;
4353: End If;
4354:
4355: IF l_dual_uom_ctl = 1 THEN
4356: l_sallocation_quantity := null;
4357: END IF;
4358:
4359: IF l_debug = 1 THEN

Line 12732: g_stmt_serial := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';

12728:
12729: ELSE
12730: --if not pick, we don't need these cursors, so we set them to
12731: -- dummy values. Used only so package will compile.
12732: g_stmt_serial := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';
12733: g_stmt_serial_validate := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';
12734: g_stmt_serial_detail := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';
12735: g_stmt_serial_detail_new := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';
12736: END IF;

Line 12733: g_stmt_serial_validate := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';

12729: ELSE
12730: --if not pick, we don't need these cursors, so we set them to
12731: -- dummy values. Used only so package will compile.
12732: g_stmt_serial := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';
12733: g_stmt_serial_validate := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';
12734: g_stmt_serial_detail := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';
12735: g_stmt_serial_detail_new := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';
12736: END IF;
12737:

Line 12734: g_stmt_serial_detail := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';

12730: --if not pick, we don't need these cursors, so we set them to
12731: -- dummy values. Used only so package will compile.
12732: g_stmt_serial := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';
12733: g_stmt_serial_validate := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';
12734: g_stmt_serial_detail := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';
12735: g_stmt_serial_detail_new := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';
12736: END IF;
12737:
12738: --get the package name

Line 12735: g_stmt_serial_detail_new := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';

12731: -- dummy values. Used only so package will compile.
12732: g_stmt_serial := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';
12733: g_stmt_serial_validate := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';
12734: g_stmt_serial_detail := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';
12735: g_stmt_serial_detail_new := 'select 1,1,sysdate,1,1,1,1,1,1,1,1,1 from dual';
12736: END IF;
12737:
12738: --get the package name
12739: getpackagename(p_rule_id, l_package_name);

Line 13801: FROM dual

13797: -- See if there are any enabled rules for Operation Plan Selection.
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

Line 14149: FROM dual

14145: -- all orgs or for the orgs in the set of MMTT records for the given move order header.
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