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_INTERFACE_LIST_LINES

Line 752: (Select 'Y' from qp_interface_list_lines

748: --);
749: --6028305
750: FROM DUAL
751: WHERE exists
752: (Select 'Y' from qp_interface_list_lines
753: WHERE orig_sys_line_ref=P_LINE_REC.ORIG_SYS_LINE_REF(I)
754: AND request_id=P_LINE_REC.REQUEST_ID(I)
755: AND process_status_flag is not null);
756:

Line 1376: from qp_interface_list_lines

1372: AND ORIG_SYS_HEADER_REF = P_LINE_REC.ORIG_SYS_HEADER_REF(I)
1373: AND P_LINE_REC.PROCESS_STATUS_FLAG(I) = 'P' --IS NULL;
1374: -- 6028305
1375: AND EXISTS (Select ORIG_SYS_LINE_REF
1376: from qp_interface_list_lines
1377: where ORIG_SYS_LINE_REF = P_LINE_REC.ORIG_SYS_LINE_REF(I)
1378: AND ORIG_SYS_HEADER_REF = P_LINE_REC.ORIG_SYS_HEADER_REF(I)
1379: AND PROCESS_STATUS_FLAG is not null
1380: AND REQUEST_ID=P_LINE_REC.REQUEST_ID(I)) ;

Line 1695: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

1691: orig_sys_pricing_attr_ref,error_message)
1692: SELECT
1693: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1694: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1695: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
1696: orig_sys_header_ref,orig_sys_line_ref,null,null, l_msg_txt
1697: FROM QP_INTERFACE_LIST_LINES qpil
1698: WHERE request_id = p_request_id
1699: AND interface_action_code = 'DELETE'

Line 1697: FROM QP_INTERFACE_LIST_LINES qpil

1693: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1694: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1695: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
1696: orig_sys_header_ref,orig_sys_line_ref,null,null, l_msg_txt
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

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 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 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 1771: UPDATE qp_interface_list_lines

1767: AND il.orig_sys_line_ref = l.orig_sys_line_ref
1768: AND il.orig_sys_header_ref = l.orig_sys_header_ref);
1769:
1770: --Set process_status_flag of sucessfully deleted records
1771: UPDATE qp_interface_list_lines
1772: SET process_status_flag ='I'
1773: WHERE process_status_flag = 'P' --IS NULL
1774: AND request_id = p_request_id
1775: AND interface_action_code = 'DELETE';

Line 1829: AND NOT EXISTS (SELECT 'Y' FROM QP_INTERFACE_LIST_LINES qpil

1825: -- If the Line is being deleted then the pricing record is automatically deleted.
1826: -- An other attempt to delete the Pricing attribute is not necessary.
1827: -- Check if the Line is also being deleted in this request.
1828: -- If so do not thrown an error that the pricing record is not found as it has already been deleted.
1829: AND NOT EXISTS (SELECT 'Y' FROM QP_INTERFACE_LIST_LINES qpil
1830: WHERE qpil.orig_sys_line_ref = qpip.orig_sys_line_ref
1831: AND qpil.orig_sys_header_ref = qpip.orig_sys_header_ref
1832: AND qpil.request_id = p_request_id
1833: AND qpil.interface_action_code = 'DELETE');