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_LIST_LINES

Line 560: INSERT INTO qp_list_lines

556: qp_bulk_loader_pub.write_log('Entering Insert Line');
557: FORALL I IN
558: P_LINE_REC.orig_sys_line_ref.FIRST..P_LINE_REC.orig_sys_line_ref.LAST
559:
560: INSERT INTO qp_list_lines
561: ( LIST_LINE_ID
562: ,CREATION_DATE
563: ,CREATED_BY
564: ,LAST_UPDATE_DATE

Line 783: UPDATE qp_list_lines

779: FOR I IN
780: P_LINE_REC.orig_sys_line_ref.FIRST..P_LINE_REC.orig_sys_line_ref.LAST
781: loop
782: --qp_bulk_loader_pub.write_log('count'|| i);
783: UPDATE qp_list_lines
784: SET LAST_UPDATE_DATE =sysdate
785: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
786: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID
787: ,PROGRAM_APPLICATION_ID =NULL

Line 1282: UPDATE qp_list_lines

1278: qp_bulk_loader_pub.write_log('Entering Update Line');
1279: FORALL I IN
1280: P_LINE_REC.orig_sys_line_ref.FIRST..P_LINE_REC.orig_sys_line_ref.LAST
1281:
1282: UPDATE qp_list_lines
1283: SET LAST_UPDATE_DATE =sysdate
1284: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
1285: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID
1286: ,PROGRAM_APPLICATION_ID =NULL

Line 1701: (SELECT 'Y' FROM QP_LIST_LINES qpl

1697: FROM QP_INTERFACE_LIST_LINES qpil
1698: WHERE request_id = p_request_id
1699: AND interface_action_code = 'DELETE'
1700: AND NOT EXISTS
1701: (SELECT 'Y' FROM QP_LIST_LINES qpl
1702: WHERE qpl.orig_sys_line_ref = qpil.orig_sys_line_ref
1703: AND qpl.orig_sys_header_ref = qpil.orig_sys_header_ref ) ;
1704:
1705: --set process status flag

Line 1716: QP_LIST_LINES l, QP_LIST_LINES ll

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'
1720: AND l.orig_sys_line_ref = il.orig_sys_line_ref

Line 1725: DELETE FROM QP_LIST_LINES

1721: AND l.orig_sys_header_ref = il.orig_sys_header_ref
1722: AND r.from_rltd_modifier_id = l.list_line_id
1723: AND r.to_rltd_modifier_id = ll.list_line_id );
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

Line 1729: QP_LIST_LINES l, QP_LIST_LINES ll

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'
1733: AND l.orig_sys_line_ref = il.orig_sys_line_ref

Line 1740: (SELECT l.list_line_id FROM QP_LIST_LINES l, QP_INTERFACE_LIST_LINES il

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
1743: AND il.interface_action_code = 'DELETE'
1744: AND il.orig_sys_line_ref = l.orig_sys_line_ref

Line 1752: FROM QP_INTERFACE_LIST_LINES il,QP_LIST_LINES l

1748:
1749: DELETE FROM QP_PRICING_ATTRIBUTES
1750: WHERE list_line_id IN
1751: (SELECT l.list_line_id
1752: FROM QP_INTERFACE_LIST_LINES il,QP_LIST_LINES l
1753: WHERE il.request_id = p_request_id
1754: AND il.process_status_flag = 'P' --IS NULL
1755: AND il.interface_action_code = 'DELETE'
1756: AND il.orig_sys_line_ref = l.orig_sys_line_ref

Line 1760: DELETE FROM QP_LIST_LINES

1756: AND il.orig_sys_line_ref = l.orig_sys_line_ref
1757: AND il.orig_sys_header_ref = l.orig_sys_header_ref);
1758:
1759:
1760: DELETE FROM QP_LIST_LINES
1761: WHERE list_line_id IN
1762: (SELECT l.list_line_id
1763: FROM QP_INTERFACE_LIST_LINES il,QP_LIST_LINES l
1764: WHERE il.request_id = p_request_id

Line 1763: FROM QP_INTERFACE_LIST_LINES il,QP_LIST_LINES l

1759:
1760: DELETE FROM QP_LIST_LINES
1761: WHERE list_line_id IN
1762: (SELECT l.list_line_id
1763: FROM QP_INTERFACE_LIST_LINES il,QP_LIST_LINES l
1764: WHERE il.request_id = p_request_id
1765: AND il.process_status_flag = 'P' --IS NULL
1766: AND il.interface_action_code = 'DELETE'
1767: AND il.orig_sys_line_ref = l.orig_sys_line_ref

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'