DBA Data[Home] [Help]

APPS.CSI_INV_TRXS_PKG dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 129: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

125:
126: CURSOR c_cycle_count_info (pc_cycle_count_entry_id IN NUMBER) is
127: SELECT mcch.cycle_count_header_id cycle_count_header_id,
128: mcch.cycle_count_header_name cycle_count_header_name
129: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
130: WHERE mcce.cycle_count_header_id = mcch.cycle_count_header_id
131: AND mcce.cycle_count_entry_id = pc_cycle_count_entry_id;
132:
133: r_cycle_count_info c_cycle_count_info%rowtype;

Line 2263: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

2259:
2260: CURSOR c_cycle_count_info (pc_cycle_count_entry_id IN NUMBER) is
2261: SELECT mcch.cycle_count_header_id cycle_count_header_id,
2262: mcch.cycle_count_header_name cycle_count_header_name
2263: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
2264: WHERE mcce.cycle_count_header_id = mcch.cycle_count_header_id
2265: AND mcce.cycle_count_entry_id = pc_cycle_count_entry_id;
2266:
2267: r_cycle_count_info c_cycle_count_info%rowtype;