APPS.CSFW_DEBRIEF_PUB dependencies on MTL_SYSTEM_ITEMS_VL

Line 156: select primary_uom_code from mtl_system_items_vl

152: cursor c_dbf_line_id is select CSF_DEBRIEF_LINES_S.nextval from dual;
153:
154: cursor c_uom_code(v_org_id number, v_item_id number)
155: is
156: select primary_uom_code from mtl_system_items_vl
157: where organization_id = v_org_id
158: and inventory_item_id = v_item_id;
159:
160: cursor c_creation_date (v_incident_id number)

Line 370: select primary_uom_code from mtl_system_items_vl

366:
367: cursor c_dbf_lineId is select CSF_DEBRIEF_LINES_S.nextval from dual;
368: cursor c_uom_code (v_org_id number, v_item_id number)
369: is
370: select primary_uom_code from mtl_system_items_vl
371: where organization_id = v_org_id
372: and inventory_item_id = v_item_id;
373:
374:

Line 508: select primary_uom_code from mtl_system_items_vl

504: select DEBRIEF_HEADER_ID from CSF_DEBRIEF_LINES where DEBRIEF_LINE_ID =
505: v_debrief_line_id ;
506:
507: cursor c_uom_code(v_org_id number, v_item_id number) is
508: select primary_uom_code from mtl_system_items_vl
509: where organization_id = v_org_id
510: and inventory_item_id = v_item_id;
511:
512: BEGIN

Line 647: select primary_uom_code from mtl_system_items_vl

643: select DEBRIEF_HEADER_ID from CSF_DEBRIEF_LINES where DEBRIEF_LINE_ID =
644: v_debrief_line_id;
645:
646: cursor c_uom_code(v_org_id number, v_item_id number) is
647: select primary_uom_code from mtl_system_items_vl
648: where organization_id = v_org_id
649: and inventory_item_id = v_item_id;
650:
651: cursor c_creation_date(v_incident_id number) is