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.INV_CYC_LOVS dependencies on MTL_CYCLE_COUNT_HEADERS

Line 86: FROM mtl_cycle_count_headers

82: container_discrepancy_option,
83: container_enabled_flag,
84: cycle_count_type,
85: schedule_empty_locations
86: FROM mtl_cycle_count_headers
87: WHERE organization_id = p_organization_id
88: AND trunc(nvl(disable_date, sysdate+1)) > trunc(sysdate) --Changed for bug 5519506
89: AND cycle_count_header_name LIKE ( p_cycle_count )
90: AND ( ( cycle_count_header_id IN (

Line 138: UPDATE mtl_cycle_count_headers

134: WHERE cycle_count_header_id = p_cycle_count_header_id
135: AND organization_id = p_organization_id;
136:
137: -- Update this value for the cycle count header
138: UPDATE mtl_cycle_count_headers
139: SET next_user_count_sequence = l_count_list_sequence + 1
140: WHERE cycle_count_header_id = p_cycle_count_header_id
141: AND organization_id = p_organization_id;
142:

Line 417: FROM mtl_cycle_count_headers

413: SELECT NVL ( serial_discrepancy_option, 2 ),
414: NVL ( container_discrepancy_option, 2 )
415: INTO l_serial_discrepancy,
416: l_container_discrepancy
417: FROM mtl_cycle_count_headers
418: WHERE cycle_count_header_id = p_cycle_count_header_id
419: AND organization_id = p_organization_id;
420:
421: -- Check to see if the serial entry exists but is in

Line 580: FROM mtl_cycle_count_headers

576: SELECT NVL ( serial_discrepancy_option, 2 ),
577: NVL ( container_discrepancy_option, 2 )
578: INTO l_serial_discrepancy,
579: l_container_discrepancy
580: FROM mtl_cycle_count_headers
581: WHERE cycle_count_header_id = p_cycle_count_header_id
582: AND organization_id = p_organization_id;
583:
584: -- Check to see if the multiple serial entry exists but

Line 639: FROM mtl_cycle_count_headers

635: ELSE
636: -- Get the container discrepancy option for the cycle count
637: SELECT NVL ( container_discrepancy_option, 2 )
638: INTO l_container_discrepancy
639: FROM mtl_cycle_count_headers
640: WHERE cycle_count_header_id = p_cycle_count_header_id
641: AND organization_id = p_organization_id;
642:
643: -- Check to see if the entry exists but

Line 1526: FROM mtl_cycle_count_headers

1522: INTO l_head_app_tol_pos,
1523: l_head_app_tol_neg,
1524: l_head_cost_tol_pos,
1525: l_head_cost_tol_neg
1526: FROM mtl_cycle_count_headers
1527: WHERE cycle_count_header_id = l_cycle_count_header_id
1528: AND organization_id = l_organization_id;
1529:
1530: /* Approval Tolerance Positive */

Line 1739: FROM mtl_cycle_count_headers

1735: NVL ( container_discrepancy_option, 2 )
1736: INTO l_container_enabled_flag,
1737: l_container_adjustment_option,
1738: l_container_discrepancy_option
1739: FROM mtl_cycle_count_headers
1740: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
1741: AND organization_id = g_cc_entry.organization_id;
1742:
1743: -- Get the cycle count header approval option code

Line 1746: FROM mtl_cycle_count_headers

1742:
1743: -- Get the cycle count header approval option code
1744: SELECT NVL ( approval_option_code, 1 )
1745: INTO l_approval_option_code
1746: FROM mtl_cycle_count_headers
1747: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
1748: AND organization_id = g_cc_entry.organization_id;
1749:
1750: IF ( l_debug = 1 ) THEN

Line 1907: FROM mtl_cycle_count_headers

1903:
1904: -- Get the required fields
1905: SELECT NVL ( approval_option_code, 1 )
1906: INTO l_approval_option_code
1907: FROM mtl_cycle_count_headers
1908: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
1909: AND organization_id = g_cc_entry.organization_id;
1910:
1911: l_parent_lpn_id := g_cc_entry.parent_lpn_id;

Line 1920: FROM mtl_cycle_count_headers

1916: NVL ( container_discrepancy_option, 2 )
1917: INTO l_container_enabled_flag,
1918: l_container_adjustment_option,
1919: l_container_discrepancy_option
1920: FROM mtl_cycle_count_headers
1921: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
1922: AND organization_id = g_cc_entry.organization_id;
1923:
1924: -- Approval is required for all adjustments

Line 1974: FROM mtl_cycle_count_headers

1970: l_auto_recount_flag,
1971: l_max_recounts,
1972: l_days_until_late,
1973: l_serial_count_option
1974: FROM mtl_cycle_count_headers
1975: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
1976: AND organization_id = g_cc_entry.organization_id;
1977:
1978: -- Get the container specific information

Line 1985: FROM mtl_cycle_count_headers

1981: NVL ( container_discrepancy_option, 2 )
1982: INTO l_container_enabled_flag,
1983: l_container_adjustment_option,
1984: l_container_discrepancy_option
1985: FROM mtl_cycle_count_headers
1986: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
1987: AND organization_id = g_cc_entry.organization_id;
1988:
1989: -- Bug 5186993

Line 2102: FROM mtl_cycle_count_headers

2098: SELECT NVL ( serial_detail_option, 1 ),
2099: NVL ( serial_count_option, 1 )
2100: INTO l_serial_detail_option,
2101: l_serial_count_option
2102: FROM mtl_cycle_count_headers
2103: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
2104: AND organization_id = g_cc_entry.organization_id;
2105:
2106: -- Set the serial detail option for the new entry

Line 2492: FROM mtl_cycle_count_headers

2488: SELECT NVL ( serial_detail_option, 1 ),
2489: NVL ( serial_count_option, 1 )
2490: INTO l_serial_detail_option,
2491: l_serial_count_option
2492: FROM mtl_cycle_count_headers
2493: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
2494: AND organization_id = g_cc_entry.organization_id;
2495:
2496: -- Compare the current entry's number of counts with the value

Line 2922: FROM mtl_cycle_count_headers

2918: SELECT NVL ( serial_count_option, 1 ),
2919: NVL ( inventory_adjustment_account, -1 )
2920: INTO l_serial_count_option,
2921: l_txn_acct_id
2922: FROM mtl_cycle_count_headers
2923: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
2924: AND organization_id = g_cc_entry.organization_id;
2925:
2926: SELECT concatenated_segments

Line 3996: FROM mtl_cycle_count_headers

3992:
3993: -- Get the serial count option
3994: /*SELECT NVL(serial_count_option, 1)
3995: INTO l_serial_count_option
3996: FROM mtl_cycle_count_headers
3997: WHERE cycle_count_header_id = l_cc_header_id
3998: AND organization_id = l_org_id;
3999:
4000: -- Unmark the serials that were marked previously

Line 4292: FROM mtl_cycle_count_headers

4288: AND organization_id = g_cc_entry.organization_id;
4289:
4290: SELECT NVL ( serial_count_option, 1 )
4291: INTO l_serial_count_option
4292: FROM mtl_cycle_count_headers
4293: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
4294: AND organization_id = g_cc_entry.organization_id;
4295:
4296: IF ( l_debug = 1 ) THEN

Line 4621: FROM mtl_cycle_count_headers

4617: AND organization_id = g_cc_entry.organization_id;
4618:
4619: SELECT NVL ( serial_count_option, 1 )
4620: INTO l_serial_count_option
4621: FROM mtl_cycle_count_headers
4622: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
4623: AND organization_id = g_cc_entry.organization_id;
4624:
4625: IF ( l_debug = 1 ) THEN

Line 5184: FROM mtl_cycle_count_headers

5180: SELECT NVL ( serial_count_option, 1 ),
5181: NVL ( serial_detail_option, 1 )
5182: INTO l_serial_count_option,
5183: l_serial_detail_option
5184: FROM mtl_cycle_count_headers
5185: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
5186: AND organization_id = g_cc_entry.organization_id;
5187:
5188: -- Get the serial number control code

Line 5320: FROM mtl_cycle_count_headers

5316: l_automatic_recount_flag,
5317: l_maximum_auto_recounts,
5318: l_days_until_late,
5319: l_approval_option_code
5320: FROM mtl_cycle_count_headers
5321: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
5322: AND organization_id = g_cc_entry.organization_id;
5323:
5324: IF ( l_serial_count_option = 3 ) THEN

Line 5568: FROM mtl_cycle_count_headers

5564: l_automatic_recount_flag,
5565: l_maximum_auto_recounts,
5566: l_days_until_late,
5567: l_approval_option_code
5568: FROM mtl_cycle_count_headers
5569: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
5570: AND organization_id = g_cc_entry.organization_id;
5571:
5572: IF ( l_debug = 1 ) THEN

Line 6098: FROM mtl_cycle_count_headers

6094: NVL ( serial_discrepancy_option, 2 )
6095: INTO l_serial_count_option,
6096: l_serial_detail,
6097: l_serial_discrepancy
6098: FROM mtl_cycle_count_headers
6099: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
6100: AND organization_id = g_cc_entry.organization_id;
6101:
6102: -- Get the serial number control code

Line 6414: FROM mtl_cycle_count_headers

6410:
6411: -- Get the cycle count header inventory adjustment account
6412: SELECT NVL ( inventory_adjustment_account, -1 )
6413: INTO l_txn_acct_id
6414: FROM mtl_cycle_count_headers
6415: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
6416: AND organization_id = g_cc_entry.organization_id;
6417:
6418: SELECT concatenated_segments

Line 6986: FROM mtl_cycle_count_headers

6982: AND organization_id = g_cc_entry.organization_id;
6983:
6984: SELECT NVL ( serial_count_option, 1 )
6985: INTO l_serial_count_option
6986: FROM mtl_cycle_count_headers
6987: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
6988: AND organization_id = g_cc_entry.organization_id;
6989:
6990: IF ( l_serial_number_ctrl_code IN ( 2, 5 ) ) THEN

Line 7091: FROM mtl_cycle_count_headers

7087: AND organization_id = g_cc_entry.organization_id;
7088:
7089: SELECT NVL ( serial_count_option, 1 )
7090: INTO l_serial_count_option
7091: FROM mtl_cycle_count_headers
7092: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
7093: AND organization_id = g_cc_entry.organization_id;
7094:
7095: SELECT NVL ( serial_number, '@@@@@' ),

Line 7301: FROM mtl_cycle_count_headers

7297:
7298: -- Get the serial count option first
7299: SELECT NVL ( serial_count_option, 1 )
7300: INTO l_serial_count_option
7301: FROM mtl_cycle_count_headers
7302: WHERE cycle_count_header_id = p_cycle_count_header_id
7303: AND organization_id = p_organization_id;
7304:
7305: /* Use the cursor that searches through all levels in the parent child relationship */

Line 7954: FROM mtl_cycle_count_headers

7950: NVL ( maximum_auto_recounts, 0 ), NVL ( days_until_late , 0 ),
7951: --Bug 6978840
7952: NVL( approval_option_code , 3)
7953: INTO l_serial_adjustment_option, l_automatic_recount_flag, l_maximum_auto_recounts, l_days_until_late, l_approval_option_code
7954: FROM mtl_cycle_count_headers
7955: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id;
7956:
7957: -- The user has selected 'Adjust if Possible' option for the serial items
7958: IF ( l_debug = 1 ) THEN

Line 8176: FROM mtl_cycle_count_headers

8172:
8173: -- Get the cycle count headers approval option code
8174: SELECT NVL ( approval_option_code, 1 )
8175: INTO l_approval_option_code
8176: FROM mtl_cycle_count_headers
8177: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
8178: AND organization_id = g_cc_entry.organization_id;
8179:
8180: -- Get the system quantity