DBA Data[Home] [Help]

APPS.POGOT_S dependencies on PO_REQUISITION_LINES

Line 268: FROM PO_REQUISITION_LINES

264: round( nvl(quantity, 0) * nvl(unit_price, 0), x_base_precision),
265: round( nvl(quantity, 0) * nvl(unit_price, 0) / x_base_min_unit)
266: * x_base_min_unit))
267: INTO x_result_fld
268: FROM PO_REQUISITION_LINES
269: WHERE requisition_header_id = x_object_id
270: AND nvl(cancel_flag, 'N') = 'N'
271: AND nvl(modified_by_agent_flag, 'N') = 'N';
272:

Line 292: FROM PO_REQUISITION_LINES

288: round( nvl(quantity, 0) * nvl(unit_price, 0), x_base_precision),
289: round( nvl(quantity, 0) * nvl(unit_price, 0) / x_base_min_unit)
290: * x_base_min_unit))
291: INTO x_result_fld
292: FROM PO_REQUISITION_LINES
293: WHERE requisition_line_id = x_object_id
294: AND nvl(cancel_flag, 'N') = 'N'
295: AND nvl(modified_by_agent_flag, 'N') = 'N';
296:

Line 678: FROM PO_REQUISITION_LINES_ALL

674: round( nvl(quantity, 0) * nvl(unit_price, 0), x_base_precision),
675: round( nvl(quantity, 0) * nvl(unit_price, 0) / x_base_min_unit)
676: * x_base_min_unit))
677: INTO x_result_fld
678: FROM PO_REQUISITION_LINES_ALL
679: WHERE requisition_header_id = x_object_id
680: AND nvl(cancel_flag, 'N') = 'N'
681: AND nvl(modified_by_agent_flag, 'N') = 'N';
682:

Line 702: FROM PO_REQUISITION_LINES_ALL

698: round( nvl(quantity, 0) * nvl(unit_price, 0), x_base_precision),
699: round( nvl(quantity, 0) * nvl(unit_price, 0) / x_base_min_unit)
700: * x_base_min_unit))
701: INTO x_result_fld
702: FROM PO_REQUISITION_LINES_ALL
703: WHERE requisition_line_id = x_object_id
704: AND nvl(cancel_flag, 'N') = 'N'
705: AND nvl(modified_by_agent_flag, 'N') = 'N';
706: