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_REQ_DISTRIBUTIONS_ALL

Line 2647: FROM po_req_distributions_all prd,

2643: l_progress VARCHAR2(3) := '000' ;
2644:
2645: CURSOR l_before_fc_csr IS
2646: SELECT DISTINCT(prd.requisition_line_id)
2647: FROM po_req_distributions_all prd,
2648: po_line_locations poll ,
2649: po_distributions_all pod
2650: WHERE pod.line_location_id = poll.line_location_id
2651: AND pod.req_distribution_id = prd.distribution_id

Line 2960: po_req_distributions_all pord,

2956: )
2957: )
2958: INTO x_qty_cancelled
2959: FROM PO_DISTRIBUTIONS_ALL POd ,
2960: po_req_distributions_all pord,
2961: po_line_locations POLL
2962: WHERE pord.requisition_line_id = p_req_line_id
2963: AND pord.distribution_id = pod.req_distribution_id
2964: AND POLL.line_location_id = POD.line_location_id

Line 3176: UPDATE PO_REQ_DISTRIBUTIONS_ALL PORD

3172: -- Note: The p_req_line_id now will be the new req line id created
3173:
3174: l_progress := '005';
3175:
3176: UPDATE PO_REQ_DISTRIBUTIONS_ALL PORD
3177: SET PORD.req_line_quantity = (SELECT Least(PORD.req_line_quantity ,
3178: sum(l_uom_conv *
3179: Greatest(NVL(POD.quantity_delivered, 0),
3180: NVL(POD.quantity_billed, 0))

Line 3198: PO_REQ_DISTRIBUTIONS_ALL PORD1 ,

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
3202: AND PORD1.requisition_line_id = PORL_OLD.requisition_line_id

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

3203: AND POD.req_distribution_id = PORD1.distribution_id
3204: AND NVL(POD.quantity_cancelled, 0) > 0 );
3205:
3206: IF g_debug_stmt THEN
3207: PO_DEBUG.debug_var(d_module, l_progress, 'Rows Updated in PO_REQ_DISTRIBUTIONS_ALL table', SQL%ROWCOUNT);
3208: END IF;
3209:
3210: l_progress := '006' ;
3211: SELECT SUM(PORD.req_line_quantity)

Line 3213: FROM PO_REQ_DISTRIBUTIONS_ALL PORD

3209:
3210: l_progress := '006' ;
3211: SELECT SUM(PORD.req_line_quantity)
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,

Line 3218: PO_REQ_DISTRIBUTIONS_ALL PORD1

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 );
3222:

Line 3442: PO_REQ_DISTRIBUTIONS_ALL PORD

3438: SELECT SUM(greatest(pod.quantity_delivered,
3439: pod.quantity_billed))
3440: INTO l_qzero
3441: FROM PO_DISTRIBUTIONS_ALL POD,
3442: PO_REQ_DISTRIBUTIONS_ALL PORD
3443: WHERE POD.req_distribution_id = PORD.distribution_id
3444: AND PORD.requisition_line_id = p_req_line_id;
3445:
3446: EXCEPTION

Line 3916: INSERT INTO PO_REQ_DISTRIBUTIONS_ALL (

3912: END IF;
3913:
3914: l_progress := '002' ;
3915:
3916: INSERT INTO PO_REQ_DISTRIBUTIONS_ALL (
3917: distribution_id ,
3918: last_update_date ,
3919: last_updated_by ,
3920: requisition_line_id ,

Line 4042: PO_REQ_DISTRIBUTIONS_ALL PORD ,

4038: ),
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 ,

Line 4341: UPDATE PO_REQ_DISTRIBUTIONS_ALL PORD

4337: x_is_new_line :='N';
4338:
4339: --The below sql will only consider the req distributions which are sourced to a blanket agreement
4340:
4341: UPDATE PO_REQ_DISTRIBUTIONS_ALL PORD
4342: SET PORD.last_update_date = SYSDATE ,
4343: PORD.last_updated_by = p_user_id ,
4344: PORD.last_update_login = p_login_id,
4345: PORD.prevent_encumbrance_flag =

Line 4388: UPDATE PO_REQ_DISTRIBUTIONS_ALL PORD

4384: -- and is backed by an encumbered BPA
4385: -- The prevent encumbrance flag to 'N' on all the req distributions
4386: -- which were processed during Reserve action
4387:
4388: UPDATE PO_REQ_DISTRIBUTIONS_ALL PORD
4389: SET PORD.last_update_date = SYSDATE,
4390: PORD.last_updated_by = p_user_id,
4391: PORD.last_update_login = p_login_id,
4392: PORD.prevent_encumbrance_flag =

Line 4426: FROM PO_REQ_DISTRIBUTIONS_ALL PORD

4422:
4423:
4424: SELECT SUM(PORD.REQ_LINE_QUANTITY)
4425: INTO l_quantity
4426: FROM PO_REQ_DISTRIBUTIONS_ALL PORD
4427: WHERE PORD.REQUISITION_LINE_ID = x_req_line_id_tbl(i);
4428:
4429: IF g_debug_stmt THEN
4430: PO_DEBUG.debug_var(d_module, l_progress, 'l_quantity', l_quantity);

Line 4557: UPDATE PO_REQ_DISTRIBUTIONS_ALL PORD

4553:
4554: END IF ; -- l_qty_cancelled<>0
4555:
4556:
4557: UPDATE PO_REQ_DISTRIBUTIONS_ALL PORD
4558: SET PORD.last_update_date = SYSDATE ,
4559: PORD.last_updated_by = p_user_id,
4560: PORD.last_update_login = p_login_id
4561: WHERE PORD.requisition_line_id = x_req_line_id_tbl(i);