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 91: FROM mtl_cycle_count_headers

87: container_discrepancy_option,
88: container_enabled_flag,
89: cycle_count_type,
90: schedule_empty_locations
91: FROM mtl_cycle_count_headers
92: WHERE organization_id = p_organization_id
93: AND trunc(nvl(disable_date, sysdate+1)) > trunc(sysdate) --Changed for bug 5519506
94: AND cycle_count_header_name LIKE ( p_cycle_count )
95: AND ( ( cycle_count_header_id IN (

Line 153: UPDATE mtl_cycle_count_headers

149: WHERE cycle_count_header_id = p_cycle_count_header_id
150: AND organization_id = p_organization_id;
151:
152: -- Update this value for the cycle count header
153: UPDATE mtl_cycle_count_headers
154: SET next_user_count_sequence = l_count_list_sequence + 1
155: WHERE cycle_count_header_id = p_cycle_count_header_id
156: AND organization_id = p_organization_id;
157:

Line 473: FROM mtl_cycle_count_headers

469: SELECT NVL ( serial_discrepancy_option, 2 ),
470: NVL ( container_discrepancy_option, 2 )
471: INTO l_serial_discrepancy,
472: l_container_discrepancy
473: FROM mtl_cycle_count_headers
474: WHERE cycle_count_header_id = p_cycle_count_header_id
475: AND organization_id = p_organization_id;
476:
477: -- Check to see if the serial entry exists but is in

Line 635: FROM mtl_cycle_count_headers

631: SELECT serial_count_option,
632: serial_detail_option
633: INTO l_serial_count_option,
634: l_serial_detail_option
635: FROM mtl_cycle_count_headers
636: WHERE cycle_count_header_id = p_cycle_count_header_id
637: AND organization_id = p_organization_id;
638:
639: IF ( l_debug = 1 ) THEN

Line 670: FROM mtl_cycle_count_headers

666: SELECT NVL ( serial_discrepancy_option, 2 ),
667: NVL ( container_discrepancy_option, 2 )
668: INTO l_serial_discrepancy,
669: l_container_discrepancy
670: FROM mtl_cycle_count_headers
671: WHERE cycle_count_header_id = p_cycle_count_header_id
672: AND organization_id = p_organization_id;
673:
674: -- Check to see if the multiple serial entry exists but

Line 729: FROM mtl_cycle_count_headers

725: ELSE
726: -- Get the container discrepancy option for the cycle count
727: SELECT NVL ( container_discrepancy_option, 2 )
728: INTO l_container_discrepancy
729: FROM mtl_cycle_count_headers
730: WHERE cycle_count_header_id = p_cycle_count_header_id
731: AND organization_id = p_organization_id;
732:
733: -- Check to see if the entry exists but

Line 1762: FROM mtl_cycle_count_headers

1758: INTO l_head_app_tol_pos,
1759: l_head_app_tol_neg,
1760: l_head_cost_tol_pos,
1761: l_head_cost_tol_neg
1762: FROM mtl_cycle_count_headers
1763: WHERE cycle_count_header_id = l_cycle_count_header_id
1764: AND organization_id = l_organization_id;
1765:
1766: /* Approval Tolerance Positive */

Line 1975: FROM mtl_cycle_count_headers

1971: NVL ( container_discrepancy_option, 2 )
1972: INTO l_container_enabled_flag,
1973: l_container_adjustment_option,
1974: l_container_discrepancy_option
1975: FROM mtl_cycle_count_headers
1976: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
1977: AND organization_id = g_cc_entry.organization_id;
1978:
1979: -- Get the cycle count header approval option code

Line 1982: FROM mtl_cycle_count_headers

1978:
1979: -- Get the cycle count header approval option code
1980: SELECT NVL ( approval_option_code, 1 )
1981: INTO l_approval_option_code
1982: FROM mtl_cycle_count_headers
1983: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
1984: AND organization_id = g_cc_entry.organization_id;
1985:
1986: IF ( l_debug = 1 ) THEN

Line 2143: FROM mtl_cycle_count_headers

2139:
2140: -- Get the required fields
2141: SELECT NVL ( approval_option_code, 1 )
2142: INTO l_approval_option_code
2143: FROM mtl_cycle_count_headers
2144: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
2145: AND organization_id = g_cc_entry.organization_id;
2146:
2147: l_parent_lpn_id := g_cc_entry.parent_lpn_id;

Line 2156: FROM mtl_cycle_count_headers

2152: NVL ( container_discrepancy_option, 2 )
2153: INTO l_container_enabled_flag,
2154: l_container_adjustment_option,
2155: l_container_discrepancy_option
2156: FROM mtl_cycle_count_headers
2157: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
2158: AND organization_id = g_cc_entry.organization_id;
2159:
2160: -- Approval is required for all adjustments

Line 2210: FROM mtl_cycle_count_headers

2206: l_auto_recount_flag,
2207: l_max_recounts,
2208: l_days_until_late,
2209: l_serial_count_option
2210: FROM mtl_cycle_count_headers
2211: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
2212: AND organization_id = g_cc_entry.organization_id;
2213:
2214: -- Get the container specific information

Line 2221: FROM mtl_cycle_count_headers

2217: NVL ( container_discrepancy_option, 2 )
2218: INTO l_container_enabled_flag,
2219: l_container_adjustment_option,
2220: l_container_discrepancy_option
2221: FROM mtl_cycle_count_headers
2222: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
2223: AND organization_id = g_cc_entry.organization_id;
2224:
2225: -- Bug 5186993

Line 2338: FROM mtl_cycle_count_headers

2334: SELECT NVL ( serial_detail_option, 1 ),
2335: NVL ( serial_count_option, 1 )
2336: INTO l_serial_detail_option,
2337: l_serial_count_option
2338: FROM mtl_cycle_count_headers
2339: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
2340: AND organization_id = g_cc_entry.organization_id;
2341:
2342: -- Set the serial detail option for the new entry

Line 2739: FROM mtl_cycle_count_headers

2735: SELECT NVL ( serial_detail_option, 1 ),
2736: NVL ( serial_count_option, 1 )
2737: INTO l_serial_detail_option,
2738: l_serial_count_option
2739: FROM mtl_cycle_count_headers
2740: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
2741: AND organization_id = g_cc_entry.organization_id;
2742:
2743: -- Compare the current entry's number of counts with the value

Line 3173: FROM mtl_cycle_count_headers

3169: SELECT NVL ( serial_count_option, 1 ),
3170: NVL ( inventory_adjustment_account, -1 )
3171: INTO l_serial_count_option,
3172: l_txn_acct_id
3173: FROM mtl_cycle_count_headers
3174: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
3175: AND organization_id = g_cc_entry.organization_id;
3176:
3177: SELECT concatenated_segments

Line 4309: FROM mtl_cycle_count_headers

4305:
4306: -- Get the serial count option
4307: /*SELECT NVL(serial_count_option, 1)
4308: INTO l_serial_count_option
4309: FROM mtl_cycle_count_headers
4310: WHERE cycle_count_header_id = l_cc_header_id
4311: AND organization_id = l_org_id;
4312:
4313: -- Unmark the serials that were marked previously

Line 4615: FROM mtl_cycle_count_headers

4611: END IF;
4612:
4613: SELECT NVL ( serial_count_option, 1 )
4614: INTO l_serial_count_option
4615: FROM mtl_cycle_count_headers
4616: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
4617: AND organization_id = g_cc_entry.organization_id;
4618:
4619: IF ( l_debug = 1 ) THEN

Line 5283: FROM mtl_cycle_count_headers

5279: SELECT NVL ( serial_count_option, 1 ),
5280: NVL ( serial_detail_option, 1 )
5281: INTO l_serial_count_option,
5282: l_serial_detail_option
5283: FROM mtl_cycle_count_headers
5284: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
5285: AND organization_id = g_cc_entry.organization_id;
5286:
5287: -- Get the serial number control code

Line 5419: FROM mtl_cycle_count_headers

5415: l_automatic_recount_flag,
5416: l_maximum_auto_recounts,
5417: l_days_until_late,
5418: l_approval_option_code
5419: FROM mtl_cycle_count_headers
5420: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
5421: AND organization_id = g_cc_entry.organization_id;
5422:
5423: IF ( l_serial_count_option = 3 ) THEN

Line 5667: FROM mtl_cycle_count_headers

5663: l_automatic_recount_flag,
5664: l_maximum_auto_recounts,
5665: l_days_until_late,
5666: l_approval_option_code
5667: FROM mtl_cycle_count_headers
5668: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
5669: AND organization_id = g_cc_entry.organization_id;
5670:
5671: IF ( l_debug = 1 ) THEN

Line 6204: FROM mtl_cycle_count_headers

6200: NVL ( serial_discrepancy_option, 2 )
6201: INTO l_serial_count_option,
6202: l_serial_detail,
6203: l_serial_discrepancy
6204: FROM mtl_cycle_count_headers
6205: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
6206: AND organization_id = g_cc_entry.organization_id;
6207:
6208: -- Get the serial number control code

Line 6520: FROM mtl_cycle_count_headers

6516:
6517: -- Get the cycle count header inventory adjustment account
6518: SELECT NVL ( inventory_adjustment_account, -1 )
6519: INTO l_txn_acct_id
6520: FROM mtl_cycle_count_headers
6521: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
6522: AND organization_id = g_cc_entry.organization_id;
6523:
6524: SELECT concatenated_segments

Line 7095: FROM mtl_cycle_count_headers

7091: AND organization_id = g_cc_entry.organization_id;
7092:
7093: SELECT NVL ( serial_count_option, 1 )
7094: INTO l_serial_count_option
7095: FROM mtl_cycle_count_headers
7096: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
7097: AND organization_id = g_cc_entry.organization_id;
7098:
7099: IF ( l_serial_number_ctrl_code IN ( 2, 5 ) ) THEN

Line 7200: FROM mtl_cycle_count_headers

7196: AND organization_id = g_cc_entry.organization_id;
7197:
7198: SELECT NVL ( serial_count_option, 1 )
7199: INTO l_serial_count_option
7200: FROM mtl_cycle_count_headers
7201: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
7202: AND organization_id = g_cc_entry.organization_id;
7203:
7204: SELECT NVL ( serial_number, '@@@@@' ),

Line 7418: FROM mtl_cycle_count_headers

7414:
7415: -- Get the serial count option first
7416: SELECT NVL ( serial_count_option, 1 )
7417: INTO l_serial_count_option
7418: FROM mtl_cycle_count_headers
7419: WHERE cycle_count_header_id = p_cycle_count_header_id
7420: AND organization_id = p_organization_id;
7421:
7422: /* Check if the LPN being Counted is an Inner LPN.

Line 8152: FROM mtl_cycle_count_headers

8148: NVL ( maximum_auto_recounts, 0 ), NVL ( days_until_late , 0 ),
8149: --Bug 6978840
8150: NVL( approval_option_code , 3)
8151: INTO l_serial_adjustment_option, l_automatic_recount_flag, l_maximum_auto_recounts, l_days_until_late, l_approval_option_code
8152: FROM mtl_cycle_count_headers
8153: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id;
8154:
8155: -- The user has selected 'Adjust if Possible' option for the serial items
8156: IF ( l_debug = 1 ) THEN

Line 8395: FROM mtl_cycle_count_headers

8391:
8392: -- Get the cycle count headers approval option code
8393: SELECT NVL ( approval_option_code, 1 )
8394: INTO l_approval_option_code
8395: FROM mtl_cycle_count_headers
8396: WHERE cycle_count_header_id = g_cc_entry.cycle_count_header_id
8397: AND organization_id = g_cc_entry.organization_id;
8398:
8399: -- Get the system quantity