eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_BULK_UTIL dependencies on QP_RLTD_MODIFIERS

Line 1715: FROM QP_INTERFACE_LIST_LINES il, QP_RLTD_MODIFIERS r,

1711: --delete if any PBH child lines
1712: DELETE FROM QP_PRICING_ATTRIBUTES
1713: WHERE list_line_id IN
1714: (SELECT ll.list_line_id
1715: FROM QP_INTERFACE_LIST_LINES il, QP_RLTD_MODIFIERS r,
1716: QP_LIST_LINES l, QP_LIST_LINES ll
1717: WHERE il.request_id = p_request_id
1718: AND il.process_status_flag = 'P' --IS NULL
1719: AND il.interface_action_code = 'DELETE'

Line 1728: FROM QP_INTERFACE_LIST_LINES il, QP_RLTD_MODIFIERS r,

1724:
1725: DELETE FROM QP_LIST_LINES
1726: WHERE list_line_id IN
1727: (SELECT ll.list_line_id
1728: FROM QP_INTERFACE_LIST_LINES il, QP_RLTD_MODIFIERS r,
1729: QP_LIST_LINES l, QP_LIST_LINES ll
1730: WHERE il.request_id = p_request_id
1731: AND il.process_status_flag = 'P' --IS NULL
1732: AND il.interface_action_code = 'DELETE'

Line 1738: DELETE FROM QP_RLTD_MODIFIERS

1734: AND l.orig_sys_header_ref = il.orig_sys_header_ref
1735: AND r.from_rltd_modifier_id = l.list_line_id
1736: AND r.to_rltd_modifier_id = ll.list_line_id );
1737:
1738: DELETE FROM QP_RLTD_MODIFIERS
1739: WHERE from_rltd_modifier_id IN
1740: (SELECT l.list_line_id FROM QP_LIST_LINES l, QP_INTERFACE_LIST_LINES il
1741: WHERE il.request_id = p_request_id
1742: AND il.process_status_flag = 'P' --IS NULL

Line 1857: FROM qp_list_lines la, qp_rltd_modifiers ra

1853: WHERE request_id = p_request_id
1854: AND process_status_flag = 'P' --is null
1855: AND interface_action_code = 'DELETE'
1856: AND EXISTS (SELECT 'PRICE BREAK CHILD LINE'
1857: FROM qp_list_lines la, qp_rltd_modifiers ra
1858: WHERE la.orig_sys_line_ref = qpip.orig_sys_line_ref
1859: AND ra.to_rltd_modifier_id = la.list_line_id
1860: AND ra.rltd_modifier_grp_type = 'PRICE BREAK'
1861: )

Line 1864: FROM qp_list_lines la, qp_rltd_modifiers ra,

1860: AND ra.rltd_modifier_grp_type = 'PRICE BREAK'
1861: )
1862: AND pricing_attr_value_to <>
1863: (SELECT max(to_number(pb.pricing_attr_value_to))
1864: FROM qp_list_lines la, qp_rltd_modifiers ra,
1865: qp_rltd_modifiers rb, qp_pricing_attributes pb
1866: WHERE la.orig_sys_line_ref = qpip.orig_sys_line_ref
1867: AND ra.to_rltd_modifier_id = la.list_line_id
1868: AND ra.rltd_modifier_grp_type = 'PRICE BREAK'

Line 1865: qp_rltd_modifiers rb, qp_pricing_attributes pb

1861: )
1862: AND pricing_attr_value_to <>
1863: (SELECT max(to_number(pb.pricing_attr_value_to))
1864: FROM qp_list_lines la, qp_rltd_modifiers ra,
1865: qp_rltd_modifiers rb, qp_pricing_attributes pb
1866: WHERE la.orig_sys_line_ref = qpip.orig_sys_line_ref
1867: AND ra.to_rltd_modifier_id = la.list_line_id
1868: AND ra.rltd_modifier_grp_type = 'PRICE BREAK'
1869: AND ra.from_rltd_modifier_id = rb.from_rltd_modifier_id