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 561: INSERT INTO qp_list_lines

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

Line 784: UPDATE qp_list_lines

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

Line 1283: UPDATE qp_list_lines

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

Line 1702: (SELECT 'Y' FROM QP_LIST_LINES qpl

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

Line 1717: QP_LIST_LINES l, QP_LIST_LINES ll

1713: DELETE FROM QP_PRICING_ATTRIBUTES
1714: WHERE list_line_id IN
1715: (SELECT ll.list_line_id
1716: FROM QP_INTERFACE_LIST_LINES il, QP_RLTD_MODIFIERS r,
1717: QP_LIST_LINES l, QP_LIST_LINES ll
1718: WHERE il.request_id = p_request_id
1719: AND il.process_status_flag = 'P' --IS NULL
1720: AND il.interface_action_code = 'DELETE'
1721: AND l.orig_sys_line_ref = il.orig_sys_line_ref

Line 1726: DELETE FROM QP_LIST_LINES

1722: AND l.orig_sys_header_ref = il.orig_sys_header_ref
1723: AND r.from_rltd_modifier_id = l.list_line_id
1724: AND r.to_rltd_modifier_id = ll.list_line_id );
1725:
1726: DELETE FROM QP_LIST_LINES
1727: WHERE list_line_id IN
1728: (SELECT ll.list_line_id
1729: FROM QP_INTERFACE_LIST_LINES il, QP_RLTD_MODIFIERS r,
1730: QP_LIST_LINES l, QP_LIST_LINES ll

Line 1730: QP_LIST_LINES l, QP_LIST_LINES ll

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

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

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

Line 1753: FROM QP_INTERFACE_LIST_LINES il,QP_LIST_LINES l

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

Line 1761: DELETE FROM QP_LIST_LINES

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

Line 1764: FROM QP_INTERFACE_LIST_LINES il,QP_LIST_LINES l

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

Line 1858: FROM qp_list_lines la, qp_rltd_modifiers ra

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

Line 1865: FROM qp_list_lines la, qp_rltd_modifiers ra,

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