DBA Data[Home] [Help]

APPS.CSI_INV_TRXS_PKG dependencies on MTL_CYCLE_COUNT_HEADERS

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 2209: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

2205:
2206: CURSOR c_cycle_count_info (pc_cycle_count_entry_id IN NUMBER) is
2207: SELECT mcch.cycle_count_header_id cycle_count_header_id,
2208: mcch.cycle_count_header_name cycle_count_header_name
2209: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
2210: WHERE mcce.cycle_count_header_id = mcch.cycle_count_header_id
2211: AND mcce.cycle_count_entry_id = pc_cycle_count_entry_id;
2212:
2213: r_cycle_count_info c_cycle_count_info%rowtype;