APPS.INV_LABEL_PVT4 dependencies on MTL_CYCLE_COUNT_HEADERS

Line 127: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;

123:
124: -- Added vendor_id and vendor_site_id to the cursor for Bug 2748297
125:
126: --Bug 4891916 -Added the variable for the cycle count name
127: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;
128:
129: CURSOR c_rti_lpn IS
130: SELECT rti.lpn_id lpn_id, rti.to_organization_id to_oragnization_id,
131: pha.segment1 purchase_order, rti.subinventory, rti.locator_id, l_receipt_number,

Line 1342: FROM mtl_cycle_count_headers mcch

1338: , mcce.locator_id
1339: , mcce.parent_lpn_id
1340: , mcch.cycle_count_header_name
1341: , ppf.full_name requestor
1342: FROM mtl_cycle_count_headers mcch
1343: , mtl_cycle_count_entries mcce
1344: , per_people_f ppf
1345: WHERE mcce.cycle_count_entry_id = p_transaction_Id
1346: AND ppf.person_id(+) = mcce.counted_by_employee_id_current

Line 1355: FROM mtl_cycle_count_headers mcch

1351: --and counter for the entry for the label printed at the time of cycle count approval
1352: CURSOR cc_det_approval IS
1353: SELECT mcch.cycle_count_header_name
1354: , ppf.full_name requestor
1355: FROM mtl_cycle_count_headers mcch
1356: , mtl_cycle_count_entries mcce
1357: , per_people_f ppf
1358: , mtl_material_transactions_temp mmtt
1359: WHERE mmtt.transaction_temp_id= p_transaction_id