DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION dependencies on MTL_UNITS_OF_MEASURE

Line 54: uom mtl_units_of_measure.unit_of_measure_tl%TYPE, -- Bug 2401933.add

50: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
51: item_revision po_requisition_lines.item_revision%TYPE,
52: item_desc po_requisition_lines.item_description%TYPE,
53: -- uom po_requisition_lines.unit_meas_lookup_code%TYPE, -- Bug 2401933.remove
54: uom mtl_units_of_measure.unit_of_measure_tl%TYPE, -- Bug 2401933.add
55: quantity po_requisition_lines.quantity%TYPE,
56: unit_price po_requisition_lines.unit_price%TYPE,
57: line_amount NUMBER,
58: need_by_date po_requisition_lines.need_by_date%TYPE,

Line 1227: mtl_units_of_measure muom, -- bug 2401933.add

1223: rql.currency_unit_price
1224: FROM po_requisition_lines rql,
1225: mtl_system_items_kfv msi,
1226: hr_locations_all hrt,
1227: mtl_units_of_measure muom, -- bug 2401933.add
1228: per_all_people_f per -- Bug 3404451
1229: WHERE rql.requisition_header_id = v_document_id
1230: AND NVL(rql.cancel_flag,'N') = 'N'
1231: AND NVL(rql.modified_by_agent_flag, 'N') = 'N'

Line 1481: mtl_units_of_measure muom, -- bug 2401933.add

1477: FROM po_requisition_lines rql,
1478: mtl_system_items_kfv msi,
1479: hr_locations_all hrt,
1480: per_all_people_f per, -- Bug 3404451
1481: mtl_units_of_measure muom, -- bug 2401933.add
1482: org_organization_definitions org
1483: WHERE rql.requisition_header_id = v_document_id
1484: AND NVL(rql.cancel_flag,'N') = 'N'
1485: AND NVL(rql.modified_by_agent_flag, 'N') = 'N'