APPS.DPP_EXECUTIONPROCESS_PUB dependencies on DPP_TRANSACTION_LINES_ALL

Line 112: FROM dpp_transaction_lines_all dtl

108: SELECT dpp.transaction_header_id
109: FROM dpp_transaction_headers_all dpp
110: WHERE dpp.transaction_header_id = p_txn_hdr_id
111: AND EXISTS (SELECT update_purchasing_docs
112: FROM dpp_transaction_lines_all dtl
113: WHERE nvl(update_purchasing_docs,'N') = 'N'
114: AND dtl.transaction_header_id = p_txn_hdr_id);
115: --Cursor for notify po
116: CURSOR get_lines_for_notifpo_csr(p_txn_hdr_id IN NUMBER)

Line 125: FROM dpp_transaction_lines_all dtl

121: --Cursor for Update inv costing
122: CURSOR get_lines_for_updateinv_csr(p_txn_hdr_id IN NUMBER)
123: IS
124: SELECT dtl.transaction_line_id
125: FROM dpp_transaction_lines_all dtl
126: WHERE dtl.transaction_header_id = p_txn_hdr_id
127: AND EXISTS (SELECT UPDATE_INVENTORY_COSTING
128: FROM dpp_transaction_lines_all
129: WHERE nvl(UPDATE_INVENTORY_COSTING,'N') = 'N'

Line 128: FROM dpp_transaction_lines_all

124: SELECT dtl.transaction_line_id
125: FROM dpp_transaction_lines_all dtl
126: WHERE dtl.transaction_header_id = p_txn_hdr_id
127: AND EXISTS (SELECT UPDATE_INVENTORY_COSTING
128: FROM dpp_transaction_lines_all
129: WHERE nvl(UPDATE_INVENTORY_COSTING,'N') = 'N'
130: AND transaction_header_id = p_txn_hdr_id)
131: AND rownum = 1;
132: --Cursor for Update item List Price

Line 137: FROM dpp_transaction_lines_all dtl

133: CURSOR get_lines_for_updlistprice_csr(p_txn_hdr_id IN NUMBER)
134: IS
135: SELECT dtl.transaction_line_id,
136: dtl.UPDATE_ITEM_LIST_PRICE
137: FROM dpp_transaction_lines_all dtl
138: WHERE dtl.transaction_header_id = p_txn_hdr_id
139: AND EXISTS (SELECT UPDATE_ITEM_LIST_PRICE
140: FROM dpp_transaction_lines_all
141: WHERE nvl(UPDATE_ITEM_LIST_PRICE,'N') = 'N'

Line 140: FROM dpp_transaction_lines_all

136: dtl.UPDATE_ITEM_LIST_PRICE
137: FROM dpp_transaction_lines_all dtl
138: WHERE dtl.transaction_header_id = p_txn_hdr_id
139: AND EXISTS (SELECT UPDATE_ITEM_LIST_PRICE
140: FROM dpp_transaction_lines_all
141: WHERE nvl(UPDATE_ITEM_LIST_PRICE,'N') = 'N'
142: AND transaction_header_id = p_txn_hdr_id)
143: AND rownum = 1;
144: --Cursor for Notify inbound price list

Line 149: FROM dpp_transaction_lines_all dtl

145: CURSOR get_lines_for_notifinpl_csr(p_txn_hdr_id IN NUMBER)
146: IS
147: SELECT dtl.transaction_line_id,
148: dtl.NOTIFY_INBOUND_PRICELIST
149: FROM dpp_transaction_lines_all dtl
150: WHERE dtl.transaction_header_id = p_txn_hdr_id
151: AND rownum = 1;
152: --Cursor for Notify outbound price list
153: CURSOR get_lines_for_notifoutpl_csr(p_txn_hdr_id IN NUMBER)

Line 157: FROM dpp_transaction_lines_all dtl

153: CURSOR get_lines_for_notifoutpl_csr(p_txn_hdr_id IN NUMBER)
154: IS
155: SELECT dtl.transaction_line_id,
156: dtl.NOTIFY_OUTBOUND_PRICELIST
157: FROM dpp_transaction_lines_all dtl
158: WHERE dtl.transaction_header_id = p_txn_hdr_id
159: AND rownum = 1;
160: --Cursor for Notify Promotions
161: CURSOR get_lines_for_notifpromo_csr(p_txn_hdr_id IN NUMBER)

Line 165: FROM dpp_transaction_lines_all dtl

161: CURSOR get_lines_for_notifpromo_csr(p_txn_hdr_id IN NUMBER)
162: IS
163: SELECT dtl.transaction_line_id,
164: dtl.NOTIFY_PROMOTIONS_PRICELIST
165: FROM dpp_transaction_lines_all dtl
166: WHERE dtl.transaction_header_id = p_txn_hdr_id
167: AND rownum = 1;
168:
169: BEGIN