APPS.CSFW_DEBRIEF_PUB dependencies on MTL_SYSTEM_ITEMS_VL

Line 195: select primary_uom_code from mtl_system_items_vl

191: cursor c_dbf_line_id is select CSF_DEBRIEF_LINES_S.nextval from dual;
192:
193: cursor c_uom_code(v_org_id number, v_item_id number)
194: is
195: select primary_uom_code from mtl_system_items_vl
196: where organization_id = v_org_id
197: and inventory_item_id = v_item_id;
198:
199: cursor c_creation_date (v_incident_id number)

Line 568: select primary_uom_code from mtl_system_items_vl

564:
565: cursor c_dbf_lineId is select CSF_DEBRIEF_LINES_S.nextval from dual;
566: cursor c_uom_code (v_org_id number, v_item_id number)
567: is
568: select primary_uom_code from mtl_system_items_vl
569: where organization_id = v_org_id
570: and inventory_item_id = v_item_id;
571:
572:

Line 859: select primary_uom_code from mtl_system_items_vl

855: select DEBRIEF_HEADER_ID from CSF_DEBRIEF_LINES where DEBRIEF_LINE_ID =
856: v_debrief_line_id ;
857:
858: cursor c_uom_code(v_org_id number, v_item_id number) is
859: select primary_uom_code from mtl_system_items_vl
860: where organization_id = v_org_id
861: and inventory_item_id = v_item_id;
862:
863: BEGIN

Line 1156: select primary_uom_code from mtl_system_items_vl

1152: select DEBRIEF_HEADER_ID from CSF_DEBRIEF_LINES where DEBRIEF_LINE_ID =
1153: v_debrief_line_id;
1154:
1155: cursor c_uom_code(v_org_id number, v_item_id number) is
1156: select primary_uom_code from mtl_system_items_vl
1157: where organization_id = v_org_id
1158: and inventory_item_id = v_item_id;
1159:
1160: cursor c_creation_date(v_incident_id number) is