APPS.DPP_EXECUTIONPROCESS_PVT dependencies on DPP_TRANSACTION_LINES_ALL

Line 110: FROM dpp_transaction_lines_all dtl

106: SELECT dpp.transaction_header_id
107: FROM dpp_transaction_headers_all dpp
108: WHERE dpp.transaction_header_id = p_txn_hdr_id
109: AND EXISTS (SELECT update_purchasing_docs
110: FROM dpp_transaction_lines_all dtl
111: WHERE nvl(update_purchasing_docs,'N') = 'N'
112: AND dtl.transaction_header_id = p_txn_hdr_id);
113:
114: --Cursor for Update inv costing

Line 117: FROM dpp_transaction_lines_all dtl

113:
114: --Cursor for Update inv costing
115: CURSOR get_lines_for_updateinv_csr(p_txn_hdr_id IN NUMBER) IS
116: SELECT dtl.transaction_line_id
117: FROM dpp_transaction_lines_all dtl
118: WHERE dtl.transaction_header_id = p_txn_hdr_id
119: AND EXISTS (SELECT UPDATE_INVENTORY_COSTING
120: FROM dpp_transaction_lines_all
121: WHERE nvl(UPDATE_INVENTORY_COSTING,'N') = 'N'

Line 120: FROM dpp_transaction_lines_all

116: SELECT dtl.transaction_line_id
117: FROM dpp_transaction_lines_all dtl
118: WHERE dtl.transaction_header_id = p_txn_hdr_id
119: AND EXISTS (SELECT UPDATE_INVENTORY_COSTING
120: FROM dpp_transaction_lines_all
121: WHERE nvl(UPDATE_INVENTORY_COSTING,'N') = 'N'
122: AND transaction_header_id = p_txn_hdr_id)
123: AND rownum = 1;
124:

Line 128: FROM dpp_transaction_lines_all dtl

124:
125: --Cursor for Update item List Price
126: CURSOR get_lines_for_updlistprice_csr(p_txn_hdr_id IN NUMBER) IS
127: SELECT dtl.transaction_line_id
128: FROM dpp_transaction_lines_all dtl
129: WHERE dtl.transaction_header_id = p_txn_hdr_id
130: AND EXISTS (SELECT UPDATE_ITEM_LIST_PRICE
131: FROM dpp_transaction_lines_all
132: WHERE nvl(UPDATE_ITEM_LIST_PRICE,'N') = 'N'

Line 131: FROM dpp_transaction_lines_all

127: SELECT dtl.transaction_line_id
128: FROM dpp_transaction_lines_all dtl
129: WHERE dtl.transaction_header_id = p_txn_hdr_id
130: AND EXISTS (SELECT UPDATE_ITEM_LIST_PRICE
131: FROM dpp_transaction_lines_all
132: WHERE nvl(UPDATE_ITEM_LIST_PRICE,'N') = 'N'
133: AND transaction_header_id = p_txn_hdr_id)
134: AND rownum = 1;
135: