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_LABEL_PVT5 dependencies on MTL_CYCLE_COUNT_HEADERS

Line 1133: FROM mtl_cycle_count_headers mcch

1129: , mcce.locator_id
1130: , mcce.parent_lpn_id
1131: , mcch.cycle_count_header_name
1132: , ppf.full_name requestor
1133: FROM mtl_cycle_count_headers mcch
1134: , mtl_cycle_count_entries mcce
1135: , per_people_f ppf
1136: WHERE mcce.cycle_count_entry_id = p_transaction_Id
1137: AND ppf.person_id(+) = mcce.counted_by_employee_id_current

Line 1147: FROM mtl_cycle_count_headers mcch

1143: --counter for the entry for the label printed at the time of cycle count approval
1144: CURSOR cc_det_approval IS
1145: SELECT mcch.cycle_count_header_name
1146: , ppf.full_name requestor
1147: FROM mtl_cycle_count_headers mcch
1148: , mtl_cycle_count_entries mcce
1149: , per_people_f ppf
1150: , mtl_material_transactions_temp mmtt
1151: WHERE mmtt.transaction_temp_id= p_transaction_id

Line 1455: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;

1451:
1452: l_count_custom_sql NUMBER := 0; -- Added for Bug#4179391
1453:
1454: --Bug 4891916. Added the local variable to store the cycle count name
1455: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;
1456: --lpn status project start
1457: l_material_status_code MTL_MATERIAL_STATUSES.STATUS_CODE%TYPE := NULL; -- Bug 13624825
1458: l_onhand_status_enabled NUMBER := 0;
1459: --lpn status project end