APPS.INV_LABEL_PVT4 dependencies on MTL_CYCLE_COUNT_HEADERS

Line 121: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;

117:
118: -- Added vendor_id and vendor_site_id to the cursor for Bug 2748297
119:
120: --Bug 4891916 -Added the variable for the cycle count name
121: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;
122:
123: CURSOR c_rti_lpn IS
124: SELECT rti.lpn_id lpn_id, rti.to_organization_id to_oragnization_id,
125: pha.segment1 purchase_order, rti.subinventory, rti.locator_id, l_receipt_number,

Line 1115: FROM mtl_cycle_count_headers mcch

1111: , mcce.locator_id
1112: , mcce.parent_lpn_id
1113: , mcch.cycle_count_header_name
1114: , ppf.full_name requestor
1115: FROM mtl_cycle_count_headers mcch
1116: , mtl_cycle_count_entries mcce
1117: , per_people_f ppf
1118: WHERE mcce.cycle_count_entry_id = p_transaction_Id
1119: AND ppf.person_id(+) = mcce.counted_by_employee_id_current

Line 1127: FROM mtl_cycle_count_headers mcch

1123: --and counter for the entry for the label printed at the time of cycle count approval
1124: CURSOR cc_det_approval IS
1125: SELECT mcch.cycle_count_header_name
1126: , ppf.full_name requestor
1127: FROM mtl_cycle_count_headers mcch
1128: , mtl_cycle_count_entries mcce
1129: , per_people_f ppf
1130: , mtl_material_transactions_temp mmtt
1131: WHERE mmtt.transaction_temp_id= p_transaction_id