DBA Data[Home] [Help]

APPS.CSD_BULK_RECEIVE_UTIL dependencies on CS_INCIDENTS_ALL_B

Line 462: from cs_incidents_all_b

458:
459: -- Cursor to get Party site use id
460: Cursor c_get_party_site_use_id (p_incident_id number )is
461: Select ship_to_site_use_id
462: from cs_incidents_all_b
463: where incident_id = p_incident_id;
464:
465: -- Cursor to derive Primary UOM code
466: Cursor c_get_item_uom_code (p_inventory_item_id number) is

Line 1221: cs_incidents_all_b cib,

1217: cpt.serial_number,
1218: mtl.concatenated_segments item_name
1219: from
1220: csd_product_txns_v cpt,
1221: cs_incidents_all_b cib,
1222: csd_repairs cr,
1223: mtl_system_items_kfv mtl
1224: where cpt.repair_line_id = p_repair_line_id
1225: and cr.repair_line_id = cpt.repair_line_id

Line 1672: from cs_incidents_all_b

1668:
1669: -- Cursor to get Incident number
1670: Cursor c_get_sr_details(p_incident_id in number) is
1671: Select incident_number
1672: from cs_incidents_all_b
1673: where incident_id = p_incident_id;
1674:
1675: -- Cursor to get Repair Order number
1676: Cursor c_get_ro_details(p_repair_line_id in number) is