DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_LINES_PKG dependencies on CSF_DEBRIEF_MAT_LINES_V

Line 55: from csf_debrief_mat_lines_v mat_v,

51: -- total debriefed qty for the item
52: cursor total_debriefed_quantity
53: is
54: select sum(mat_v.quantity)
55: from csf_debrief_mat_lines_v mat_v,
56: csf_debrief_headers dbf_hdr
57: where mat_v.debrief_header_id = dbf_hdr.debrief_header_id
58: and dbf_hdr.debrief_header_id = p_dbf_hdr_id
59: and mat_v.inventory_item_id = p_inventory_item_id;