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.PO_DOCUMENT_CANCEL_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 2673: FROM po_requisition_lines_all prl,

2669:
2670:
2671: CURSOR l_after_fc_csr IS
2672: SELECT DISTINCT(prl.requisition_line_id)
2673: FROM po_requisition_lines_all prl,
2674: po_line_locations poll
2675: WHERE prl.line_location_id= (-1 * poll.line_location_id)
2676: AND NVL(poll.cancel_flag, 'N') = 'Y'
2677: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 2852: FROM PO_REQUISITION_LINES_ALL PORL,

2848: POL.UNIT_MEAS_LOOKUP_CODE,
2849: PORL.UNIT_MEAS_LOOKUP_CODE,
2850: PORL.ITEM_ID)
2851: INTO x_uom_conv
2852: FROM PO_REQUISITION_LINES_ALL PORL,
2853: po_line_locations POLL ,
2854: po_lines POL
2855: WHERE PORL.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
2856: AND POLL.PO_LINE_ID = POL.PO_LINE_ID

Line 2865: FROM PO_REQUISITION_LINES_ALL PORL,

2861: POL.UNIT_MEAS_LOOKUP_CODE,
2862: PORL.UNIT_MEAS_LOOKUP_CODE,
2863: PORL.ITEM_ID)
2864: INTO x_uom_conv
2865: FROM PO_REQUISITION_LINES_ALL PORL,
2866: po_line_locations POLL ,
2867: po_lines POL
2868: WHERE (-1)*PORL.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
2869: AND POLL.PO_LINE_ID = POL.PO_LINE_ID

Line 3139: UPDATE PO_REQUISITION_LINES_ALL PORL

3135:
3136: l_progress := '003' ;
3137:
3138: -- Set the cancel_flag to Y and set back the line_location id to positive
3139: UPDATE PO_REQUISITION_LINES_ALL PORL
3140: SET PORL.cancel_flag = 'Y' ,
3141: PORL.contractor_status = NULL ,
3142: PORL.cancel_date = SYSDATE ,
3143: PORL.line_location_id = -1 * PORL.line_location_id,

Line 3148: PO_DEBUG.debug_var(d_module, l_progress, 'Rows Updated in PO_REQUISITION_LINES_ALL table', SQL%ROWCOUNT);

3144: PORL.quantity_cancelled = l_qty_cancelled
3145: WHERE PORL.requisition_line_id = p_req_line_id;
3146:
3147: IF g_debug_stmt THEN
3148: PO_DEBUG.debug_var(d_module, l_progress, 'Rows Updated in PO_REQUISITION_LINES_ALL table', SQL%ROWCOUNT);
3149: END IF;
3150:
3151:
3152: ELSE --p_recreate_demand_flag ='Y'

Line 3196: FROM PO_REQUISITION_LINES_ALL PORL_NEW,

3192: PORD.last_updated_by = p_user_id,
3193: PORD.last_update_login = p_login_id
3194: WHERE PORD.distribution_id IN (
3195: SELECT PORD1.distribution_id
3196: FROM PO_REQUISITION_LINES_ALL PORL_NEW,
3197: PO_REQUISITION_LINES_ALL PORL_OLD,
3198: PO_REQ_DISTRIBUTIONS_ALL PORD1 ,
3199: PO_DISTRIBUTIONS POD
3200: WHERE PORL_NEW.requisition_line_id = p_req_line_id

Line 3197: PO_REQUISITION_LINES_ALL PORL_OLD,

3193: PORD.last_update_login = p_login_id
3194: WHERE PORD.distribution_id IN (
3195: SELECT PORD1.distribution_id
3196: FROM PO_REQUISITION_LINES_ALL PORL_NEW,
3197: PO_REQUISITION_LINES_ALL PORL_OLD,
3198: PO_REQ_DISTRIBUTIONS_ALL PORD1 ,
3199: PO_DISTRIBUTIONS POD
3200: WHERE PORL_NEW.requisition_line_id = p_req_line_id
3201: AND PORL_OLD.requisition_line_id = (-1) * PORL_NEW.parent_req_line_id

Line 3216: FROM PO_REQUISITION_LINES_ALL PORL_NEW,

3212: INTO l_qty_cancelled
3213: FROM PO_REQ_DISTRIBUTIONS_ALL PORD
3214: WHERE PORD.distribution_id IN (
3215: SELECT PORD1.distribution_id
3216: FROM PO_REQUISITION_LINES_ALL PORL_NEW,
3217: PO_REQUISITION_LINES_ALL PORL_OLD,
3218: PO_REQ_DISTRIBUTIONS_ALL PORD1
3219: WHERE PORL_NEW.requisition_line_id= p_req_line_id
3220: AND PORL_OLD.requisition_line_id= (-1) * PORL_NEW.parent_req_line_id

Line 3217: PO_REQUISITION_LINES_ALL PORL_OLD,

3213: FROM PO_REQ_DISTRIBUTIONS_ALL PORD
3214: WHERE PORD.distribution_id IN (
3215: SELECT PORD1.distribution_id
3216: FROM PO_REQUISITION_LINES_ALL PORL_NEW,
3217: PO_REQUISITION_LINES_ALL PORL_OLD,
3218: PO_REQ_DISTRIBUTIONS_ALL PORD1
3219: WHERE PORL_NEW.requisition_line_id= p_req_line_id
3220: AND PORL_OLD.requisition_line_id= (-1) * PORL_NEW.parent_req_line_id
3221: AND PORD1.requisition_line_id = PORL_OLD.requisition_line_id );

Line 3230: UPDATE PO_REQUISITION_LINES_ALL PORL

3226:
3227: l_progress := '007' ;
3228:
3229: -- Updating the Old Req Line
3230: UPDATE PO_REQUISITION_LINES_ALL PORL
3231: SET(
3232: PORL.QUANTITY ,
3233: PORL.LAST_UPDATE_DATE,
3234: PORL.LAST_UPDATED_BY ,

Line 3249: FROM PO_REQUISITION_LINES_ALL PORL_NEW

3245: WHERE PORL.line_location_id = POLL.line_location_id
3246: AND POLL.po_line_id = POL.po_line_id)
3247: WHERE PORL.requisition_line_id = (
3248: SELECT ((-1) * PORL_NEW.parent_req_line_id)
3249: FROM PO_REQUISITION_LINES_ALL PORL_NEW
3250: WHERE PORL_NEW.requisition_line_id = p_req_line_id );
3251:
3252: IF g_debug_stmt THEN
3253: PO_DEBUG.debug_var(d_module, l_progress, 'Rows Updated in PO_REQUISITION_LINES_ALL table', SQL%ROWCOUNT);

Line 3253: PO_DEBUG.debug_var(d_module, l_progress, 'Rows Updated in PO_REQUISITION_LINES_ALL table', SQL%ROWCOUNT);

3249: FROM PO_REQUISITION_LINES_ALL PORL_NEW
3250: WHERE PORL_NEW.requisition_line_id = p_req_line_id );
3251:
3252: IF g_debug_stmt THEN
3253: PO_DEBUG.debug_var(d_module, l_progress, 'Rows Updated in PO_REQUISITION_LINES_ALL table', SQL%ROWCOUNT);
3254: END IF;
3255:
3256: l_progress := '008' ;
3257:

Line 3262: FROM PO_REQUISITION_LINES_ALL PORL_OLD,

3258: SELECT PORL_OLD.PARENT_REQ_LINE_ID,
3259: PRH.AUTHORIZATION_STATUS
3260: INTO l_parent_req_line_id,
3261: l_auth_status
3262: FROM PO_REQUISITION_LINES_ALL PORL_OLD,
3263: PO_REQUISITION_LINES_ALL PORL_NEW,
3264: PO_REQUISITION_HEADERS_ALL PRH
3265: WHERE PORL_OLD.requisition_line_id = (-1) * PORL_NEW.parent_req_line_id
3266: AND PRH.requisition_header_id = PORL_NEW.requisition_header_id

Line 3263: PO_REQUISITION_LINES_ALL PORL_NEW,

3259: PRH.AUTHORIZATION_STATUS
3260: INTO l_parent_req_line_id,
3261: l_auth_status
3262: FROM PO_REQUISITION_LINES_ALL PORL_OLD,
3263: PO_REQUISITION_LINES_ALL PORL_NEW,
3264: PO_REQUISITION_HEADERS_ALL PRH
3265: WHERE PORL_OLD.requisition_line_id = (-1) * PORL_NEW.parent_req_line_id
3266: AND PRH.requisition_header_id = PORL_NEW.requisition_header_id
3267: AND PORL_NEW.requisition_line_id = p_req_line_id;

Line 3280: UPDATE PO_REQUISITION_LINES_ALL PORL

3276: -- It should be Y only if Req Header is in Approved status
3277:
3278: l_progress := '009' ;
3279: -- Updating the new line to free it up,
3280: UPDATE PO_REQUISITION_LINES_ALL PORL
3281: SET PORL.LINE_LOCATION_ID = NULL,
3282: PORL.PARENT_REQ_LINE_ID = DECODE(l_parent_req_line_id,
3283: -9999,
3284: NULL,

Line 3299: 'Rows Updated in PO_REQUISITION_LINES_ALL table',

3295:
3296: IF g_debug_stmt THEN
3297: PO_DEBUG.debug_var(d_module,
3298: l_progress,
3299: 'Rows Updated in PO_REQUISITION_LINES_ALL table',
3300: SQL%ROWCOUNT);
3301: END IF;
3302:
3303:

Line 3310: FROM PO_REQUISITION_LINES_ALL PORL,

3306: l_progress := '010' ;
3307:
3308: SELECT PRH.AUTHORIZATION_STATUS
3309: INTO l_auth_status
3310: FROM PO_REQUISITION_LINES_ALL PORL,
3311: PO_REQUISITION_HEADERS_ALL PRH
3312: WHERE PRH.requisition_header_id = PORL.requisition_header_id
3313: AND PORL.requisition_line_id = p_req_line_id;
3314:

Line 3325: UPDATE PO_REQUISITION_LINES_ALL PORL

3321: -- It should be Y only if Req Header is in Approved status
3322:
3323: l_progress := '009' ;
3324: -- Updating the new line to free it up,
3325: UPDATE PO_REQUISITION_LINES_ALL PORL
3326: SET PORL.LINE_LOCATION_ID = NULL,
3327: LAST_UPDATE_DATE = SYSDATE ,
3328: LAST_UPDATED_BY = p_user_id ,
3329: LAST_UPDATE_LOGIN = p_login_id ,

Line 3340: 'Rows Updated in PO_REQUISITION_LINES_ALL table',

3336:
3337: IF g_debug_stmt THEN
3338: PO_DEBUG.debug_var(d_module,
3339: l_progress,
3340: 'Rows Updated in PO_REQUISITION_LINES_ALL table',
3341: SQL%ROWCOUNT);
3342: END IF;
3343:
3344: END IF; -- If p_is_new_req_line ='Y'

Line 3553: FROM po_requisition_lines_all porl

3549: x_return_status := FND_API.G_RET_STS_SUCCESS;
3550:
3551: SELECT NVL(MAX(porl.line_num), 0) + 1
3552: INTO l_next_line_num
3553: FROM po_requisition_lines_all porl
3554: WHERE porl.requisition_header_id
3555: =(SELECT requisition_header_id
3556: FROM po_requisition_lines_all
3557: WHERE requisition_line_id = p_old_line_id);

Line 3556: FROM po_requisition_lines_all

3552: INTO l_next_line_num
3553: FROM po_requisition_lines_all porl
3554: WHERE porl.requisition_header_id
3555: =(SELECT requisition_header_id
3556: FROM po_requisition_lines_all
3557: WHERE requisition_line_id = p_old_line_id);
3558:
3559: l_progress := '002' ;
3560:

Line 3570: INSERT INTO PO_REQUISITION_LINES_ALL(

3566: PO_DEBUG.debug_var(d_module, l_progress, 'x_new_line_id', x_new_line_id);
3567: PO_DEBUG.debug_var(d_module, l_progress, 'l_next_line_num', l_next_line_num);
3568: END IF;
3569:
3570: INSERT INTO PO_REQUISITION_LINES_ALL(
3571: REQUISITION_LINE_ID ,
3572: REQUISITION_HEADER_ID ,
3573: LINE_NUM ,
3574: LINE_TYPE_ID ,

Line 3778: PO_REQUISITION_LINES_ALL PORL,

3774: PORL.DROP_SHIP_FLAG ,
3775: PORL.CATALOG_TYPE ,
3776: PORL.CATALOG_SOURCE
3777: FROM
3778: PO_REQUISITION_LINES_ALL PORL,
3779: po_line_locations POLL ,
3780: po_lines POL
3781: WHERE
3782: PORL.REQUISITION_LINE_ID = p_old_line_id

Line 4043: PO_REQUISITION_LINES_ALL PORL_OLD,

4039: 'N')
4040:
4041: FROM
4042: PO_REQ_DISTRIBUTIONS_ALL PORD ,
4043: PO_REQUISITION_LINES_ALL PORL_OLD,
4044: PO_REQUISITION_LINES_ALL PORL_NEW,
4045: PO_DISTRIBUTIONS_ALL POD ,
4046: PO_LINE_LOCATIONS PLL ,
4047: po_headers BLANKET

Line 4044: PO_REQUISITION_LINES_ALL PORL_NEW,

4040:
4041: FROM
4042: PO_REQ_DISTRIBUTIONS_ALL PORD ,
4043: PO_REQUISITION_LINES_ALL PORL_OLD,
4044: PO_REQUISITION_LINES_ALL PORL_NEW,
4045: PO_DISTRIBUTIONS_ALL POD ,
4046: PO_LINE_LOCATIONS PLL ,
4047: po_headers BLANKET
4048: WHERE

Line 4264: UPDATE PO_REQUISITION_LINES_ALL PORL

4260: x_is_new_line :='N';
4261: -- Update Cancel_flag to 'I' for the req line and line_location_id
4262: -- to -line_location_id, so that it will not be fetched else where
4263: -- till this cancel action completes
4264: UPDATE PO_REQUISITION_LINES_ALL PORL
4265: SET PORL.cancel_flag = 'I' ,
4266: PORL.LAST_UPDATE_DATE = SYSDATE ,
4267: PORL.LAST_UPDATED_BY = p_user_id ,
4268: PORL.LAST_UPDATE_LOGIN = p_login_id,

Line 4355: FROM PO_REQUISITION_LINES_ALL PORL,

4351: BLANKET.org_id,
4352: BLANKET.encumbrance_required_flag,
4353: NULL)),
4354: 'N')
4355: FROM PO_REQUISITION_LINES_ALL PORL,
4356: PO_DISTRIBUTIONS_ALL POD ,
4357: po_line_locations PLL ,
4358: po_headers BLANKET
4359: WHERE PORL.requisition_line_id = PORD.requisition_line_id

Line 4369: FROM po_requisition_lines_all porl

4365: 'BLANKET')
4366: AND PORL.blanket_po_header_id = BLANKET.po_header_id)
4367: WHERE PORD.requisition_line_id= x_req_line_id_tbl(i)
4368: AND EXISTS (SELECT 1
4369: FROM po_requisition_lines_all porl
4370: WHERE porl.requisition_line_id = PORD.requisition_line_id
4371: AND porl.blanket_po_header_id IS NOT NULL);
4372:
4373: IF g_debug_stmt THEN

Line 4400: FROM po_requisition_lines_all porl

4396: 'N',
4397: pord.prevent_encumbrance_flag)
4398: WHERE PORD.requisition_line_id = x_req_line_id_tbl(i)
4399: AND EXISTS (SELECT 1
4400: FROM po_requisition_lines_all porl
4401: WHERE porl.requisition_line_id = PORD.requisition_line_id
4402: AND porl.blanket_po_header_id IS NULL)
4403: AND EXISTS (SELECT 1
4404: FROM po_distributions_all poda,

Line 4435: UPDATE PO_REQUISITION_LINES_ALL PORL

4431: END IF;
4432:
4433: l_progress := '007';
4434:
4435: UPDATE PO_REQUISITION_LINES_ALL PORL
4436: SET(
4437: PORL.LINE_LOCATION_ID,
4438: PORL.QUANTITY ,
4439: PORL.LAST_UPDATE_DATE,

Line 4545: UPDATE PO_REQUISITION_LINES_ALL PORL

4541: -- Note that the "after_fc" cursor in fetch_req_lines does not
4542: -- fetch these Req lines, as their line_location_id had never
4543: -- been negated.
4544:
4545: UPDATE PO_REQUISITION_LINES_ALL PORL
4546: SET PORL.cancel_flag = 'Y',--doubt
4547: PORL.contractor_status = NULL ,
4548: PORL.cancel_date = SYSDATE ,
4549: PORL.last_update_date = SYSDATE ,

Line 6556: po_requisition_lines_all PRL,

6552: BEGIN
6553: SELECT COUNT(*)
6554: INTO l_cto_order
6555: FROM po_requisition_headers_all PRH,
6556: po_requisition_lines_all PRL,
6557: po_line_locations POLL
6558: WHERE PRH.interface_source_code = 'CTO'
6559: AND PRH.requisition_header_id = PRL.requisition_header_id
6560: AND PRL.line_location_id = POLL.line_location_id