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_RELGEN_PKG dependencies on PO_LINE_LOCATIONS

Line 238: /Bug 7609663: Update the approved_flag in po_releses_all and po_line_locations_all /

234: -- Update Release with status INCOMPLETE
235: -- as the tax calculation has failed
236: --
237:
238: /*Bug 7609663: Update the approved_flag in po_releses_all and po_line_locations_all */
239:
240: UPDATE po_releases_all por
241: SET por.authorization_status = 'INCOMPLETE',
242: por.approved_flag = 'N'

Line 245: UPDATE po_line_locations_all plla

241: SET por.authorization_status = 'INCOMPLETE',
242: por.approved_flag = 'N'
243: WHERE por.po_release_id = x_po_release_id;
244:
245: UPDATE po_line_locations_all plla
246: SET plla.approved_flag = 'N'
247: WHERE plla.po_release_id = x_po_release_id;
248:
249: /* Bug 7609663: end */

Line 361: UPDATE po_line_locations_all plla

357: por.approved_flag = 'N',
358: por.approved_date = NULL
359: WHERE por.po_release_id = x_po_release_id;
360:
361: UPDATE po_line_locations_all plla
362: SET plla.approved_flag = 'N',
363: plla.approved_date = NULL,
364: plla.lcm_flag = NULL
365: WHERE plla.po_release_id = x_po_release_id

Line 511: /Bug 7609663: Update the approved_flag in po_releses_all and po_line_locations_all /

507: -- ECO Bug 4643026
508: -- Update Release with status INCOMPLETE
509: -- as the tax calculation has failed
510: --
511: /*Bug 7609663: Update the approved_flag in po_releses_all and po_line_locations_all */
512:
513: UPDATE po_releases_all por
514: SET por.authorization_status = 'INCOMPLETE',
515: por.approved_flag = 'N'

Line 518: UPDATE po_line_locations_all plla

514: SET por.authorization_status = 'INCOMPLETE',
515: por.approved_flag = 'N'
516: WHERE por.po_release_id = x_po_release_id;
517:
518: UPDATE po_line_locations_all plla
519: SET plla.approved_flag = 'N'
520: WHERE plla.po_release_id = x_po_release_id;
521:
522: /* Bug 7609663: end */

Line 618: UPDATE po_line_locations_all plla

614: por.approved_flag = 'N',
615: por.approved_date = NULL
616: WHERE por.po_release_id = x_po_release_id;
617:
618: UPDATE po_line_locations_all plla
619: SET plla.approved_flag = 'N',
620: plla.approved_date = NULL,
621: plla.lcm_flag = NULL
622: WHERE plla.po_release_id = x_po_release_id

Line 876: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;

872: l_promised_date DATE := NULL;
873: l_po_promised_def_prf VARCHAR2(1) := fnd_profile.value('PO_NEED_BY_PROMISE_DEFAULTING');
874: --
875:
876: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;
877: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950
878: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950
879: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950
880:

Line 904: SELECT PO_LINE_LOCATIONS_S.NEXTVAL

900: END IF;
901: END IF;
902: --
903:
904: SELECT PO_LINE_LOCATIONS_S.NEXTVAL
905: INTO x_line_location_id
906: FROM SYS.DUAL;
907:
908: /* Bug 1834138. pchintal. Commented the below SQL and added new Code

Line 914: FROM PO_LINE_LOCATIONS

910: improving the performance of the create releases process.
911:
912: SELECT NVL(MAX(SHIPMENT_NUM) +1,1)
913: INTO x_shipment_num
914: FROM PO_LINE_LOCATIONS
915: WHERE PO_RELEASE_ID = x_po_release_id;
916: */
917:
918: Gship_num_prev :=Gship_num_prev+1;

Line 1127: INSERT INTO PO_LINE_LOCATIONS(

1123: );
1124: END IF;
1125: -- Bug 3570793 END
1126:
1127: INSERT INTO PO_LINE_LOCATIONS(
1128: LINE_LOCATION_ID,
1129: LAST_UPDATE_DATE,
1130: LAST_UPDATED_BY,
1131: PO_HEADER_ID,

Line 1570: PO_LINE_LOCATIONS PLL

1566: PH.Org_Id --
1567: FROM PO_REQ_DISTRIBUTIONS PRD,
1568: PO_REQUISITION_LINES PRL,
1569: PO_HEADERS PH,
1570: PO_LINE_LOCATIONS PLL
1571: WHERE PRD.REQUISITION_LINE_ID = req_line.requisition_line_id
1572: AND PRL.REQUISITION_LINE_ID = req_line.requisition_line_id
1573: AND PH.PO_HEADER_ID = req_line.blanket_po_header_id
1574: AND PLL.LINE_LOCATION_ID = x_line_location_id;

Line 1587: FROM PO_LINE_LOCATIONS POLL,

1583: --
1584:
1585: SELECT POLL.quantity
1586: INTO x_shipment_quantity
1587: FROM PO_LINE_LOCATIONS POLL,
1588: PO_REQUISITION_LINES PORL
1589: WHERE POLL.LINE_LOCATION_ID = PORL.LINE_LOCATION_ID
1590: AND PORL.REQUISITION_LINE_ID
1591: = req_line.requisition_line_id;

Line 1595: FROM PO_LINE_LOCATIONS POLL,

1591: = req_line.requisition_line_id;
1592:
1593: SELECT SUM(POD.QUANTITY_ORDERED)
1594: INTO x_dist_quantity
1595: FROM PO_LINE_LOCATIONS POLL,
1596: PO_REQUISITION_LINES PORL,
1597: PO_DISTRIBUTIONS POD
1598: WHERE POLL.LINE_LOCATION_ID = PORL.LINE_LOCATION_ID
1599: AND PORL.REQUISITION_LINE_ID

Line 1612: PO_LINE_LOCATIONS POLL,

1608: = POD.QUANTITY_ORDERED + x_qty_difference
1609: WHERE POD.PO_DISTRIBUTION_ID =
1610: (SELECT POD2.PO_DISTRIBUTION_ID
1611: FROM PO_DISTRIBUTIONS POD2,
1612: PO_LINE_LOCATIONS POLL,
1613: PO_REQUISITION_LINES PORL
1614: WHERE POD2.LINE_LOCATION_ID
1615: = POLL.LINE_LOCATION_ID
1616: AND POLL.LINE_LOCATION_ID

Line 1985: po_line_locations poll,

1981: pod.destination_organization_id,
1982: pod.destination_subinventory,
1983: 'Y'
1984: from po_distributions pod,
1985: po_line_locations poll,
1986: po_lines pol
1987: where poll.line_location_id = x_line_location_id
1988: and nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1989: and nvl(poll.closed_code, 'OPEN') <> 'CLOSED'

Line 2196: FROM PO_LINE_LOCATIONS

2192: -- Hence, added a nvl for it.
2193:
2194: SELECT nvl(SUM(QUANTITY - nvl(QUANTITY_CANCELLED, 0)), 0)
2195: INTO x_price_break_quantity
2196: FROM PO_LINE_LOCATIONS
2197: WHERE PO_LINE_ID = req_line.blanket_po_line_id
2198: AND SHIPMENT_TYPE <> 'PRICE BREAK';
2199:
2200: -- End of fix. Bug 521788, lpo, 03/26/98

Line 2234: FROM PO_LINE_LOCATIONS

2230: /* Determine the final price for the item shipment */
2231:
2232: SELECT LEAST(NVL(MIN(PRICE_OVERRIDE), x_po_line_price), x_po_line_price)
2233: INTO x_best_price
2234: FROM PO_LINE_LOCATIONS
2235: WHERE SHIPMENT_TYPE = 'PRICE BREAK'
2236: AND PO_LINE_ID = req_line.blanket_po_line_id
2237: AND QUANTITY <= x_price_break_quantity
2238: AND (SHIP_TO_LOCATION_ID = NVL(x_ship_to_location_id,

Line 2286: FROM po_line_locations poll

2282: x_check_status := FND_API.G_RET_STS_SUCCESS; -- Bug 2701147
2283:
2284: SELECT nvl(sum(poll.quantity * poll.price_override),0)
2285: INTO release_amount
2286: FROM po_line_locations poll
2287: WHERE poll.po_release_id = x_po_release_id
2288: AND poll.shipment_type = 'BLANKET';
2289:
2290: SELECT nvl(sum(poll.quantity * poll.price_override),0)

Line 2292: FROM po_line_locations poll,

2288: AND poll.shipment_type = 'BLANKET';
2289:
2290: SELECT nvl(sum(poll.quantity * poll.price_override),0)
2291: INTO total_release_amount
2292: FROM po_line_locations poll,
2293: po_releases por,
2294: po_headers poh
2295: WHERE poh.po_header_id = x_old_po_header_id
2296: AND poll.po_header_id = poh.po_header_id

Line 2527: FROM PO_LINE_LOCATIONS POLL,

2523: nvl(POL.line_num,0) line_num,
2524: nvl(POLL.quantity,0) quantity,
2525: nvl(POL.item_id,0) item_id,
2526: nvl( POLL.line_location_id,0) line_loc_id
2527: FROM PO_LINE_LOCATIONS POLL,
2528: PO_LINE_TYPES PLT,
2529: PO_LINES POL,
2530: PO_DISTRIBUTIONS POD
2531: WHERE POLL.po_line_id = POL.po_line_id

Line 2548: PO_LINE_LOCATIONS POLL,

2544: PRL.unit_meas_lookup_code,
2545: min(POL.line_num),
2546: min(POLL.shipment_num)
2547: FROM PO_REQUISITION_LINES PRL,
2548: PO_LINE_LOCATIONS POLL,
2549: PO_LINES POL
2550: WHERE PRL.line_location_id = POLL.line_location_id
2551: AND POLL.line_location_id = p_line_location_id
2552: AND PRL.unit_price >= 0

Line 2563: PO_LINE_LOCATIONS POLL,

2559: sum(PD.quantity_ordered),
2560: min(POL.line_num),
2561: min(POLL.shipment_num)
2562: FROM PO_REQUISITION_LINES PRL,
2563: PO_LINE_LOCATIONS POLL,
2564: PO_LINES POL,
2565: PO_DISTRIBUTIONS PD,
2566: PO_REQ_DISTRIBUTIONS PRD
2567: WHERE POLL.line_location_id = p_line_location_id

Line 2633: PO_LINE_LOCATIONS POLL

2629: BEGIN
2630: SELECT round(l_ship_price_in_base_curr(shipment_line),nvl(FND.extended_precision,5))
2631: INTO l_ship_price_ext_precn
2632: FROM FND_CURRENCIES FND, PO_HEADERS POH,
2633: PO_LINE_LOCATIONS POLL
2634: WHERE POH.po_header_id = POLL.po_header_id
2635: AND POH.currency_code = FND.currency_code
2636: AND POLL.line_location_id = l_line_location_id(shipment_line);
2637: EXCEPTION

Line 2946: FROM PO_LINES POL,PO_RELEASES POR,PO_LINE_LOCATIONS PLL

2942: g_linemsg||g_delim||POL.line_num||
2943: g_delim||l_textline||g_delim||POL.min_release_amount,1,240)
2944: --Bug 12553671 end
2945: BULK COLLECT INTO l_error_messages
2946: FROM PO_LINES POL,PO_RELEASES POR,PO_LINE_LOCATIONS PLL
2947: , PO_HEADERS POH --Bug 12553671, Added table
2948: WHERE POH.po_header_id = POL.po_header_id --Bug 12553671
2949: AND PLL.po_release_id = POR.po_release_id
2950: AND PLL.po_release_id = x_po_release_id

Line 2969: FROM PO_LINE_LOCATIONS PLL2

2965: )
2966: )
2967: )
2968: )
2969: FROM PO_LINE_LOCATIONS PLL2
2970: WHERE PLL2.po_line_id = POL.po_line_id
2971: AND PLL2.po_release_id = POR.po_release_id
2972: AND PLL2.shipment_type in ('BLANKET', 'SCHEDULED')
2973: )

Line 2980: FROM PO_LINE_LOCATIONS PLL2

2976: decode(sum(nvl(PLL2.quantity,0)-nvl(PLL2.quantity_cancelled,0)),
2977: 0,POL.min_release_amount,
2978: sum((nvl(PLL2.quantity,0)-nvl(PLL2.quantity_cancelled,0))
2979: *PLL2.price_override))
2980: FROM PO_LINE_LOCATIONS PLL2
2981: WHERE PLL2.po_line_id = POL.po_line_id
2982: AND PLL2.po_release_id = POR.po_release_id
2983: AND PLL2.shipment_type in ('BLANKET', 'SCHEDULED'))*/
2984: GROUP BY POH.segment1, POL.line_num,POL.min_release_amount; --12553671

Line 3024: FROM PO_DISTRIBUTIONS POD, PO_LINE_LOCATIONS PLL, PO_LINES POL

3020: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_PDOI_INVALID_GL_ENC_PER');
3021: SELECT substr(l_textline,1,240),
3022: POD.po_distribution_id
3023: BULK COLLECT INTO l_error_messages, l_dist_id
3024: FROM PO_DISTRIBUTIONS POD, PO_LINE_LOCATIONS PLL, PO_LINES POL
3025: WHERE POD.line_location_id = PLL.line_location_id
3026: AND PLL.po_release_id = x_po_release_id
3027: AND POL.po_line_id = PLL.po_line_id
3028: AND nvl(POD.encumbered_flag,'N') = 'N'

Line 3082: FROM MTL_UOM_CLASS_CONVERSIONS MOU, PO_LINE_LOCATIONS POLL,

3078: SELECT substr(l_textline||g_delim||
3079: MTL1.uom_class||' , '||MTL2.uom_class,1,240),
3080: POLL.line_location_id
3081: BULK COLLECT INTO l_error_messages, l_line_location_id
3082: FROM MTL_UOM_CLASS_CONVERSIONS MOU, PO_LINE_LOCATIONS POLL,
3083: PO_LINES POL, MTL_UOM_CLASSES_TL MTL1,
3084: MTL_UOM_CLASSES_TL MTL2
3085: WHERE MOU.inventory_item_id = POL.item_id
3086: AND (NVL(MOU.disable_date, TRUNC(SYSDATE)) + 1) < TRUNC(SYSDATE)

Line 3129: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,

3125: SELECT substr(g_reqmsg||g_delim||p_req_num||g_delim||
3126: g_linemsg||g_delim||p_req_line_num||
3127: g_delim||l_textline,1,240)
3128: BULK COLLECT INTO l_error_messages
3129: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3130: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3131: FINANCIALS_SYSTEM_PARAMETERS FSP
3132: WHERE POR.po_release_id = x_po_release_id
3133: AND POR.po_header_id = POH.po_header_id

Line 3203: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,

3199: SELECT substr(g_reqmsg||g_delim||p_req_num||g_delim||
3200: g_linemsg||g_delim||p_req_line_num||
3201: g_delim||l_textline,1,240)
3202: BULK COLLECT INTO l_error_messages
3203: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3204: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3205: FINANCIALS_SYSTEM_PARAMETERS FSP
3206: WHERE POR.po_release_id = x_po_release_id
3207: AND POR.po_header_id = POH.po_header_id

Line 3318: PO_LINE_LOCATIONS_ALL PLL

3314:
3315: SELECT substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||l_textline,1,240)
3316: BULK COLLECT INTO l_error_messages
3317: FROM PO_RELEASES_ALL POR,
3318: PO_LINE_LOCATIONS_ALL PLL
3319: WHERE POR.po_release_id = PLL.po_release_id
3320: AND POR.po_release_id = x_po_release_id
3321: AND Nvl(PLL.LCM_FLAG,'N') = 'Y'
3322: AND Nvl(PLL.match_option,'P') <> 'R';

Line 3345: PO_LINE_LOCATIONS_GT PLL,

3341: SELECT substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||g_distmsg||g_delim||
3342: POD.distribution_num||g_delim||l_textline, 1,240)
3343: BULK COLLECT INTO l_error_messages
3344: FROM PO_RELEASES_GT POR,
3345: PO_LINE_LOCATIONS_GT PLL,
3346: PO_DISTRIBUTIONS_GT POD
3347: WHERE POR.po_release_id = POD.po_release_id
3348: AND POD.line_location_id = PLL.line_location_id
3349: AND POR.po_release_id = x_po_release_id