DBA Data[Home] [Help]

APPS.QP_CROSS_ORDER_VOLUME_LOAD dependencies on GL_SETS_OF_BOOKS

Line 270: FROM gl_sets_of_books gsob

266: -- Cursor to get set of books id.
267:
268: CURSOR Cur_get_sob_currency(psob_id NUMBER) IS
269: SELECT gsob.currency_code
270: FROM gl_sets_of_books gsob
271: WHERE gsob.set_of_books_id = psob_id;
272:
273: -- Cursor to get all items which have cross order volume pricing attributes defined
274:

Line 433: gl_sets_of_books gsob

429: p_request_id
430: FROM oe_order_headers_all hdrs,
431: oe_order_lines_all lines,
432: hr_operating_units hou,
433: gl_sets_of_books gsob
434: WHERE hdrs.header_id = lines.header_id
435: AND lines.org_id = hou.organization_id
436: AND hou.set_of_books_id = gsob.set_of_books_id
437: AND lines.inventory_item_id = i.c_inventory_item_id

Line 661: gl_sets_of_books gsob

657: P_request_id
658: FROM oe_order_headers_all hdrs,
659: oe_order_lines_all lines,
660: hr_operating_units hou,
661: gl_sets_of_books gsob
662: WHERE hdrs.header_id = lines.header_id
663: AND lines.org_id = hou.organization_id
664: AND hou.set_of_books_id = gsob.set_of_books_id
665: AND lines.line_category_code <> 'RETURN'