APPS.CSD_RECALLS_PVT dependencies on CSD_RECALL_HEADERS_B

Line 412: csd_recall_headers_b crh

408: -- print the header.
409: SELECT recall_number
410: INTO l_recall_number
411: FROM csd_recall_lines crl,
412: csd_recall_headers_b crh
413: WHERE crl.processing_group_id = p_group_id
414: AND crl.recall_id = crh.recall_id
415: AND rownum < 2;
416:

Line 1245: FROM csd_recall_headers_b,csd_recall_statuses_b crs

1241: END IF;
1242: ELSE
1243: INSERT INTO csd_recall_metrics(metric_id,recall_number)
1244: (SELECT csd_recall_metrics_s1.NEXTVAL,recall_number
1245: FROM csd_recall_headers_b,csd_recall_statuses_b crs
1246: WHERE recall_flow_status_id = crs.status_id
1247: AND crs.status_code <> 'C'
1248: AND NOT EXISTS ( SELECT 'exists'
1249: FROM csd_recall_metrics crm

Line 1251: AND recall_id in (SELECT MAX(recall_id) FROM csd_recall_headers_b

1247: AND crs.status_code <> 'C'
1248: AND NOT EXISTS ( SELECT 'exists'
1249: FROM csd_recall_metrics crm
1250: WHERE crm.recall_number = recall_number )
1251: AND recall_id in (SELECT MAX(recall_id) FROM csd_recall_headers_b
1252: GROUP BY recall_number ));
1253:
1254: SELECT DISTINCT metric_id
1255: BULK COLLECT INTO l_metric_ids

Line 1257: csd_recall_headers_b crh,

1253:
1254: SELECT DISTINCT metric_id
1255: BULK COLLECT INTO l_metric_ids
1256: FROM csd_recall_metrics crm,
1257: csd_recall_headers_b crh,
1258: csd_recall_statuses_b crs
1259: WHERE crh.recall_number = crm.recall_number
1260: AND crh.recall_flow_status_id = crs.status_id
1261: AND crs.status_code <> 'C'

Line 1269: csd_recall_headers_b crh,

1265: -- number of units recalled.
1266: SELECT crh.recall_number,SUM(cii.quantity)
1267: BULK COLLECT INTO l_recall_numbers,l_gen_num_tbl
1268: FROM csd_recall_metrics crm,
1269: csd_recall_headers_b crh,
1270: csd_recall_lines crl,
1271: csi_item_instances cii
1272: WHERE crm.metric_id IN (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))
1273: AND crm.recall_number = crh.recall_number

Line 1289: csd_recall_headers_b crh,

1285:
1286: SELECT crh.recall_number, COUNT(DISTINCT crl.owner_party_id)
1287: BULK COLLECT INTO l_recall_numbers,l_gen_num_tbl
1288: FROM csd_recall_metrics crm,
1289: csd_recall_headers_b crh,
1290: csd_recall_lines crl
1291: WHERE crm.metric_id IN (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))
1292: AND crm.recall_number = crh.recall_number
1293: AND crh.recall_id = crl.recall_id

Line 1308: csd_recall_headers_b crh,

1304: SELECT crh.recall_number,
1305: SUM(wpb.tl_resource_in+pl_resource_in+tl_overhead_in+pl_material_in+pl_material_overhead_in+pl_overhead_in)
1306: BULK COLLECT INTO l_recall_numbers, l_accumulated_cost
1307: FROM csd_recall_metrics crm,
1308: csd_recall_headers_b crh,
1309: csd_recall_lines crl,
1310: csd_repair_job_xref crj,
1311: wip_period_balances wpb
1312: WHERE crm.metric_id IN

Line 1335: csd_recall_headers_b crh,

1331: FROM
1332: (SELECT crh.recall_number,
1333: SUM(crj.quantity) quantity
1334: FROM csd_recall_metrics crm,
1335: csd_recall_headers_b crh,
1336: csd_recall_lines crl,
1337: csd_repair_job_xref crj
1338: WHERE crm.metric_id IN
1339: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)) )

Line 1360: csd_recall_headers_b crh,

1356:
1357: SELECT crh.recall_number,
1358: SUM(cii.quantity) quantity
1359: FROM csd_recall_metrics crm,
1360: csd_recall_headers_b crh,
1361: csd_recall_lines crl,
1362: csi_item_instances cii,
1363: cs_incidents_all_b sr,
1364: cs_incident_statuses_b cis

Line 1391: FROM csd_recall_headers_b crh,

1387: -- find out the number of units considered for accrued cost calculation.
1388: l_recall_numbers_temp := l_recall_numbers;
1389: SELECT crh.recall_number, SUM(crj.quantity)
1390: BULK COLLECT INTO l_recall_numbers,l_wip_jobs_with_costs
1391: FROM csd_recall_headers_b crh,
1392: csd_recall_lines crl,
1393: csd_repair_job_xref crj
1394: WHERE crh.recall_number IN
1395: ( SELECT * FROM TABLE(CAST(l_recall_numbers_temp AS JTF_VARCHAR2_TABLE_100)))

Line 1418: csd_recall_headers_b crh,

1414: SELECT crh.recall_number,
1415: SUM(cii.quantity)
1416: BULK COLLECT INTO l_recall_numbers,l_gen_num_tbl
1417: FROM csd_recall_metrics crm,
1418: csd_recall_headers_b crh,
1419: csd_recall_lines crl,
1420: cs_incidents_all_b sr,
1421: cs_incident_statuses_b cis,
1422: csi_item_instances cii

Line 1462: csd_recall_headers_b crh,

1458: FROM (
1459: SELECT crh.recall_number,
1460: COUNT(crl.owner_party_id) party_id
1461: FROM csd_recall_metrics crm,
1462: csd_recall_headers_b crh,
1463: csd_recall_lines crl,
1464: cs_incidents_all_b sr,
1465: cs_incident_statuses_b cis
1466: WHERE crm.metric_id IN

Line 1475: FROM csd_recall_headers_b crh1,

1471: AND sr.incident_status_id = cis.incident_status_id
1472: AND cis.status_code = 'CLOSED'
1473: AND NOT EXISTS
1474: (SELECT 'exists'
1475: FROM csd_recall_headers_b crh1,
1476: csd_recall_lines crl1,
1477: cs_incidents_all_b sr1,
1478: cs_incident_statuses_b cis1,
1479: csd_recall_metrics crm1