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_INTERFACE_S dependencies on PO_LINE_LOCATIONS_ALL

Line 1118: update po_line_locations_all

1114: approved_date = sysdate,
1115: approved_flag = 'Y'
1116: where po_header_id = x_document_id;
1117:
1118: update po_line_locations_all
1119: set approved_flag = 'Y',
1120: approved_date = sysdate
1121: where po_header_id = x_document_id ;
1122:

Line 1132: update po_line_locations_all

1128: approved_date = sysdate,
1129: approved_flag = 'Y'
1130: where po_release_id = x_document_id;
1131:
1132: update po_line_locations_all
1133: set approved_flag = 'Y',
1134: approved_date = sysdate
1135: where po_release_id = x_document_id ;
1136:

Line 2686: l_price_break_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;--

2682:
2683: x_line_location_id number := null;
2684: l_line_loc_id_tbl po_tbl_number;
2685:
2686: l_price_break_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;--
2687:
2688: x_quote_header_id number := null;
2689: x_quote_line_id number := null;
2690: x_match_blanket_line varchar2(1) := null;

Line 2787: l_min_shipment_num po_line_locations_all.shipment_num%TYPE;

2783:
2784: -- oneoff 3201308 start
2785: l_needby_prf varchar2(1);
2786: l_shipto_prf varchar2(1);
2787: l_min_shipment_num po_line_locations_all.shipment_num%TYPE;
2788: l_ship_to_loc po_line_locations_all.ship_to_location_id%TYPE;
2789: l_ship_to_org po_line_locations_all.ship_to_organization_id%TYPE;
2790: l_need_by_date po_line_locations_all.need_by_date%TYPE;
2791: -- oneoff 3201308 end

Line 2788: l_ship_to_loc po_line_locations_all.ship_to_location_id%TYPE;

2784: -- oneoff 3201308 start
2785: l_needby_prf varchar2(1);
2786: l_shipto_prf varchar2(1);
2787: l_min_shipment_num po_line_locations_all.shipment_num%TYPE;
2788: l_ship_to_loc po_line_locations_all.ship_to_location_id%TYPE;
2789: l_ship_to_org po_line_locations_all.ship_to_organization_id%TYPE;
2790: l_need_by_date po_line_locations_all.need_by_date%TYPE;
2791: -- oneoff 3201308 end
2792:

Line 2789: l_ship_to_org po_line_locations_all.ship_to_organization_id%TYPE;

2785: l_needby_prf varchar2(1);
2786: l_shipto_prf varchar2(1);
2787: l_min_shipment_num po_line_locations_all.shipment_num%TYPE;
2788: l_ship_to_loc po_line_locations_all.ship_to_location_id%TYPE;
2789: l_ship_to_org po_line_locations_all.ship_to_organization_id%TYPE;
2790: l_need_by_date po_line_locations_all.need_by_date%TYPE;
2791: -- oneoff 3201308 end
2792:
2793: l_contractor_status PO_REQUISITION_LINES_ALL.contractor_status%TYPE;

Line 2790: l_need_by_date po_line_locations_all.need_by_date%TYPE;

2786: l_shipto_prf varchar2(1);
2787: l_min_shipment_num po_line_locations_all.shipment_num%TYPE;
2788: l_ship_to_loc po_line_locations_all.ship_to_location_id%TYPE;
2789: l_ship_to_org po_line_locations_all.ship_to_organization_id%TYPE;
2790: l_need_by_date po_line_locations_all.need_by_date%TYPE;
2791: -- oneoff 3201308 end
2792:
2793: l_contractor_status PO_REQUISITION_LINES_ALL.contractor_status%TYPE;
2794: --

Line 2819: l_outsourced_assembly po_line_locations_all.outsourced_assembly%type; --

2815: l_interface_header_id_tbl interface_header_id_tbl;
2816: l_interface_line_id_tbl interface_line_id_tbl;
2817: --
2818:
2819: l_outsourced_assembly po_line_locations_all.outsourced_assembly%type; --
2820: l_retainage_rate PO_VENDOR_SITES_ALL.retainage_rate%type; --bug#5255878
2821: BEGIN
2822: l_outsourced_assembly :=2; --
2823: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 4536: from po_line_locations_all poll

4532: poll.need_by_date
4533: into l_ship_to_loc,
4534: l_ship_to_org,
4535: l_need_by_date
4536: from po_line_locations_all poll
4537: where poll.po_line_id = x_po_line_id
4538: and poll.shipment_num = l_min_shipment_num;
4539: EXCEPTION
4540: when others then

Line 4622: UPDATE po_line_locations_all

4618:
4619: --
4620: --All the shipments which have been created need to get the
4621: --new price as on the line for Standard POs.
4622: UPDATE po_line_locations_all
4623: -- Bug 3417479
4624: -- SET price_override = x_unit_price
4625: SET price_override = nvl(x_unit_price, price_override)
4626: -- Bug 4902592. Not setting tax_attribute_update_code here because

Line 5289: l_manual_price_change_flag po_line_locations_all.manual_price_change_flag%TYPE := NULL; --bug 3495772

5285: --
5286:
5287: l_api_name CONSTANT VARCHAR2(30) := 'create_shipment';
5288: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >
5289: l_manual_price_change_flag po_line_locations_all.manual_price_change_flag%TYPE := NULL; --bug 3495772
5290:
5291: -- Bug 5208159
5292: l_from_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5293:

Line 5480: FROM po_line_locations_all poll, --

5476: l_progress := '060';
5477: BEGIN
5478: SELECT poll.line_location_id,poll.secondary_unit_of_measure --
5479: INTO x_line_location_id,x_secondary_unit_of_measure
5480: FROM po_line_locations_all poll, --
5481: po_lines_all pol --
5482: WHERE poll.po_header_id = interface.po_header_id
5483: AND poll.po_line_id = pol.po_line_id
5484: AND poll.shipment_num = interface.shipment_num

Line 5514: FROM po_line_locations_all poll, --

5510: poll.secondary_unit_of_measure --
5511: INTO x_line_location_id,
5512: l_manual_price_change_flag, --bug 3495772
5513: x_secondary_unit_of_measure
5514: FROM po_line_locations_all poll, --
5515: po_lines_all pol, --
5516: po_releases_all por --
5517: WHERE poll.po_header_id = interface.po_header_id
5518: AND poll.po_line_id = pol.po_line_id

Line 5575: from po_line_locations_all --

5571: if (x_line_location_id is not null and x_cumulative_flag = FALSE) then
5572: begin
5573: select nvl(quantity, 0)
5574: into x_ship_qty
5575: from po_line_locations_all --
5576: where line_location_id = x_line_location_id;
5577: exception
5578: when others THEN
5579: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 5697: UPDATE po_line_locations_all --

5693:
5694:
5695: -- replace interface.secondary_quantity with x_secondary_quantity
5696:
5697: UPDATE po_line_locations_all --
5698: SET quantity = quantity + x_quantity,
5699: -- start of 1548597
5700: secondary_quantity = secondary_quantity + x_secondary_quantity,
5701: -- end of 1548597

Line 6060: INSERT INTO po_line_locations_all --

6056: X_secondary_unit_of_measure := null;
6057: END IF;
6058: --
6059:
6060: INSERT INTO po_line_locations_all --
6061: (line_location_id,
6062: last_update_date,
6063: last_updated_by,
6064: po_header_id,

Line 6359: FROM PO_LINE_LOCATIONS_ALL --

6355: SELECT PO_HEADER_ID
6356: ,PO_LINE_ID
6357: INTO x_p_po_header_id
6358: ,x_p_po_line_id
6359: FROM PO_LINE_LOCATIONS_ALL --
6360: WHERE LINE_LOCATION_ID = x_line_location_id;
6361: EXCEPTION
6362: WHEN NO_DATA_FOUND THEN
6363: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 6841: from po_line_locations_all where

6837: --!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
6838: --bug#3603067 need to get the value of drop ship flag for the shipment
6839: begin
6840: select nvl(drop_ship_flag,'N') into l_drop_ship_flag
6841: from po_line_locations_all where
6842: line_location_id=x_line_location_id;
6843: exception
6844: when others then
6845: null;

Line 6852: FROM po_distributions_interface pdi, po_line_locations_all poll

6848:
6849: BEGIN
6850: SELECT pdi.amount_ordered
6851: INTO l_amount_ordered
6852: FROM po_distributions_interface pdi, po_line_locations_all poll
6853: WHERE pdi.interface_header_id = interface.interface_header_id
6854: AND pdi.interface_line_id = interface.interface_line_id
6855: AND poll.line_location_id = x_line_location_id;
6856:

Line 7117: FROM po_distributions_interface pdi, po_line_locations_all poll

7113: g_purchasing_ou_id, --
7114: poll.shipment_type, --
7115: nvl2(g_calculate_tax_flag, 'CREATE', null), --
7116: pdi.interface_distribution_ref --
7117: FROM po_distributions_interface pdi, po_line_locations_all poll
7118: WHERE pdi.interface_header_id = interface.interface_header_id
7119: AND pdi.interface_line_id = interface.interface_line_id
7120: AND poll.line_location_id = x_line_location_id; --
7121:

Line 7228: l_shipment_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;

7224:
7225: l_sum_dist_amounts PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE;
7226: l_last_dist_amount PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE;
7227: l_last_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
7228: l_shipment_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
7229:
7230: BEGIN
7231:
7232: l_progress:='000'; PO_DEBUG.debug_begin(l_log_head);

Line 7255: FROM po_line_locations_all

7251: -- Get the shipment amount ================================================
7252: --
7253: SELECT amount
7254: INTO l_shipment_amount
7255: FROM po_line_locations_all
7256: WHERE line_location_id = p_line_location_id;
7257:
7258: l_progress:='040'; PO_DEBUG.debug_var(l_log_head,l_progress,'l_shipment_amount',l_shipment_amount);
7259:

Line 7326: l_shipment_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;

7322:
7323: l_sum_dist_quantities PO_DISTRIBUTIONS_ALL.quantity_ordered%TYPE;
7324: l_last_dist_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
7325: l_last_dist_qty PO_DISTRIBUTIONS_ALL.quantity_ordered%TYPE;
7326: l_shipment_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
7327:
7328: BEGIN
7329:
7330: d_progress := 0;

Line 7352: FROM po_line_locations_all poll

7348: END IF;
7349:
7350: SELECT poll.quantity
7351: INTO l_shipment_quantity
7352: FROM po_line_locations_all poll
7353: WHERE poll.line_location_id = p_line_location_id;
7354:
7355: d_progress := 30;
7356:

Line 10525: po_line_locations_all poll,

10521:
10522: SELECT nvl(max(poll.shipment_num),0)
10523: INTO x_shipment_num
10524: FROM po_headers_all ph,
10525: po_line_locations_all poll,
10526: po_releases_all pr
10527: WHERE ph.po_header_id = poll.po_header_id
10528: AND ph.segment1 = x_document_num
10529: AND pr.po_header_id = ph.po_header_id

Line 11867: FROM PO_LINE_LOCATIONS_ALL PLL --

11863: SELECT PLL.shipment_num
11864: ,PLL.line_location_id
11865: INTO x_po_shipment_num
11866: ,x_line_location_to_check
11867: FROM PO_LINE_LOCATIONS_ALL PLL --
11868: WHERE PLL.PO_LINE_ID = x_po_line_id
11869: -- bug 4599140 (included the following OR condition so that the SQL works correctly
11870: -- for null need_by_date)
11871: AND (( to_char(PLL.need_by_date-(to_number(substr(to_char(PLL.need_by_date,

Line 11915: FROM PO_LINE_LOCATIONS_ALL PLL --

11911: SELECT PLL.shipment_num
11912: ,PLL.line_location_id
11913: INTO x_po_shipment_num
11914: ,x_line_location_to_check
11915: FROM PO_LINE_LOCATIONS_ALL PLL --
11916: WHERE PLL.PO_LINE_ID = x_po_line_id
11917: AND PLL.SHIP_TO_LOCATION_ID = x_ship_to_location_id
11918: AND PLL.SHIP_TO_ORGANIZATION_ID =
11919: x_destination_org_id

Line 11958: FROM PO_LINE_LOCATIONS_ALL PLL --

11954: SELECT PLL.shipment_num
11955: ,PLL.line_location_id
11956: INTO x_po_shipment_num
11957: ,x_line_location_to_check
11958: FROM PO_LINE_LOCATIONS_ALL PLL --
11959: WHERE PLL.PO_LINE_ID = x_po_line_id
11960: AND nvl(PLL.drop_ship_flag, 'N') <> 'Y' -- cannot add to Drop Ship Shipments
11961: AND nvl(PLL.CONSIGNED_FLAG,'N') = nvl(x_consigned_flag,'N')
11962: AND ROWNUM = 1

Line 11997: FROM PO_LINE_LOCATIONS_ALL PLL, --

11993: -- a new shipment or not
11994:
11995: SELECT PLL.shipment_num
11996: INTO x_po_shipment_num
11997: FROM PO_LINE_LOCATIONS_ALL PLL, --
11998: PO_REQUISITION_LINES_ALL PRL, --
11999: PO_SYSTEM_PARAMETERS_ALL PSP --
12000: WHERE PLL.LINE_LOCATION_ID = x_line_location_to_check
12001: AND PRL.REQUISITION_LINE_ID = x_requisition_line_id

Line 12068: FROM PO_LINE_LOCATIONS_ALL PLL, --

12064: BEGIN
12065:
12066: SELECT PLL.shipment_num
12067: INTO x_po_shipment_num
12068: FROM PO_LINE_LOCATIONS_ALL PLL, --
12069: PO_REQUISITION_LINES_ALL PRL, --
12070: PO_SYSTEM_PARAMETERS_ALL PSP --
12071: WHERE PLL.PO_LINE_ID = x_po_line_id
12072: AND PRL.REQUISITION_LINE_ID = x_requisition_line_id

Line 12184: FROM PO_LINE_LOCATIONS_ALL PLL, --

12180: SELECT PLL.shipment_num
12181: ,PLL.line_location_id
12182: INTO x_po_shipment_num,
12183: x_line_location_to_check
12184: FROM PO_LINE_LOCATIONS_ALL PLL, --
12185: PO_LINES_ALL POL, --
12186: PO_LINE_TYPES PLT --
12187: WHERE POL.PO_LINE_ID = l_po_line_id -- bug2788115
12188: AND POL.po_line_id = PLL.po_line_id --

Line 12833: from po_line_locations_all poll --

12829: ELSE
12830: l_progress := '060';
12831: select nvl(max(shipment_num),0)
12832: into x_shipment_num
12833: from po_line_locations_all poll --
12834: where poll.po_line_id = x_po_line_id
12835: and poll.shipment_type in ('STANDARD', 'PLANNED', 'RFQ');
12836:
12837: -- Bug 605715, lpo, 01/05/98

Line 12861: po_line_locations_all poll, --

12857:
12858: select nvl(max(shipment_num),0)
12859: into x_shipment_num
12860: from po_headers_all ph, --
12861: po_line_locations_all poll, --
12862: po_releases_all pr --
12863: where ph.po_header_id = poll.po_header_id
12864: and ph.segment1 = x_document_num
12865: and pr.po_header_id = ph.po_header_id

Line 13223: records from po_lines_interface table to po_line_locations_all table

13219: /*============================================================================
13220: Name : CREATE_PRICE_BREAK
13221: Type : Private
13222: Function : This procedure is called from 'create_line'. This procedure inserts
13223: records from po_lines_interface table to po_line_locations_all table
13224: for the price break information.
13225: Pre-req : None
13226: Parameters:
13227: IN : p_po_line_id IN NUMBER REQUIRED

Line 13973: -- PO_LINE_LOCATIONS_ALL

13969: --Name: create_payitems
13970: --Pre-reqs:
13971: -- PO Line has been created.
13972: --Modifies:
13973: -- PO_LINE_LOCATIONS_ALL
13974: --Locks:
13975: -- None.
13976: --Function:
13977: -- Create all payitems for a PO Line. If PO_LINE_LOCATIONS_INTERFACE is

Line 13989: -- in po_line_locations_all

13985: -- p_ext_precision: extended precision of the currency desired.
13986: -- Used to round prices
13987: -- OUT:
13988: -- x_line_location_id: id of the first actuals (STANDARD) payitem
13989: -- in po_line_locations_all
13990: -- x_line_loc_id_tbl: ids of all payitems created in po_line_locations_all
13991: --Notes:
13992: -- None
13993: --Testing:

Line 13990: -- x_line_loc_id_tbl: ids of all payitems created in po_line_locations_all

13986: -- Used to round prices
13987: -- OUT:
13988: -- x_line_location_id: id of the first actuals (STANDARD) payitem
13989: -- in po_line_locations_all
13990: -- x_line_loc_id_tbl: ids of all payitems created in po_line_locations_all
13991: --Notes:
13992: -- None
13993: --Testing:
13994: -- None

Line 14018: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;

14014: l_line_quantity PO_LINES_ALL.quantity%TYPE;
14015: l_line_amount PO_LINES_ALL.amount%TYPE;
14016: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;
14017:
14018: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;
14019: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
14020: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
14021: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
14022: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;

Line 14019: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;

14015: l_line_amount PO_LINES_ALL.amount%TYPE;
14016: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;
14017:
14018: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;
14019: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
14020: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
14021: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
14022: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;
14023:

Line 14020: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;

14016: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;
14017:
14018: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;
14019: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
14020: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
14021: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
14022: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;
14023:
14024: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;

Line 14021: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;

14017:
14018: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;
14019: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
14020: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
14021: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
14022: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;
14023:
14024: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;
14025: l_req_tax_user_override_flag PO_REQUISITION_LINES_ALL.tax_user_override_flag%TYPE;

Line 14022: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;

14018: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;
14019: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
14020: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
14021: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
14022: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;
14023:
14024: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;
14025: l_req_tax_user_override_flag PO_REQUISITION_LINES_ALL.tax_user_override_flag%TYPE;
14026: l_req_tax_status_indicator PO_REQUISITION_LINES_ALL.tax_status_indicator%TYPE;

Line 14041: l_line_loc_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

14037: l_payitem_tax_code_id_tbl po_tbl_number;
14038: l_payitems_created NUMBER;
14039:
14040: l_routing_name RCV_ROUTING_HEADERS.routing_name%TYPE;
14041: l_line_loc_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
14042:
14043: l_po_promised_def_prf VARCHAR2(1) := FND_PROFILE.value('PO_NEED_BY_PROMISE_DEFAULTING');
14044: l_country_of_origin_code VARCHAR2(2);
14045: l_tax_status VARCHAR2(10);

Line 14374: -- origin before inserting a new row into po_line_locations_all

14370: l_payitems_created := 0;
14371:
14372: -- now iterate over the rows in the interface table
14373: -- for each row, get the default tax, receiving controls, and country of
14374: -- origin before inserting a new row into po_line_locations_all
14375:
14376: OPEN poll_interface_cursor(p_interface_line_id);
14377: LOOP
14378:

Line 14423: PO_LOG.stmt(d_module, d_progress, 'Inserting payitem into po_line_locations_all');

14419: );
14420:
14421: d_progress := 210;
14422: IF (PO_LOG.d_stmt) THEN
14423: PO_LOG.stmt(d_module, d_progress, 'Inserting payitem into po_line_locations_all');
14424: END IF;
14425:
14426: -- insert payitem into po_line_locations_all
14427:

Line 14426: -- insert payitem into po_line_locations_all

14422: IF (PO_LOG.d_stmt) THEN
14423: PO_LOG.stmt(d_module, d_progress, 'Inserting payitem into po_line_locations_all');
14424: END IF;
14425:
14426: -- insert payitem into po_line_locations_all
14427:
14428: --SQL WHAT: Insert payitem, using info in po_line_locations_interface
14429: --SQL WHY : This allows us to insert all payitems in one location.
14430:

Line 14431: INSERT INTO po_line_locations_all

14427:
14428: --SQL WHAT: Insert payitem, using info in po_line_locations_interface
14429: --SQL WHY : This allows us to insert all payitems in one location.
14430:
14431: INSERT INTO po_line_locations_all
14432: (
14433: line_location_id
14434: , last_update_date
14435: , last_updated_by

Line 14756: po_line_locations_all poll

14752: , poll.payment_type
14753: , pod.distribution_type
14754: , pod.rate
14755: FROM po_distributions_all pod,
14756: po_line_locations_all poll
14757: WHERE poll.po_line_id = p_po_line_id
14758: AND pod.line_location_id = poll.line_location_id
14759: AND pod.req_distribution_id IS NULL;
14760:

Line 14995: FROM po_line_locations_all poll

14991: THEN NULL
14992: ELSE ROUND((prd.req_line_amount / prl.amount) * poll.amount, p_precision)
14993: END)
14994: ,nvl2(g_calculate_tax_flag, 'CREATE', null) --
14995: FROM po_line_locations_all poll
14996: , po_req_distributions_all prd
14997: , po_requisition_lines_all prl
14998: WHERE poll.po_line_id = p_po_line_id
14999: AND prd.requisition_line_id = p_req_line_id

Line 15126: FROM po_line_locations_all poll

15122: , poll.quantity
15123: , poll.amount
15124: , params.sob_id
15125: ,nvl2(g_calculate_tax_flag, 'CREATE', null) --
15126: FROM po_line_locations_all poll
15127: , po_line_locations_interface polli
15128: WHERE poll.po_line_id = p_po_line_id
15129: AND poll.line_location_id = polli.line_location_id
15130: AND poll.payment_type <> 'ADVANCE';

Line 15236: FROM po_line_locations_all adv,

15232: , pod.expenditure_organization_id
15233: , pod.expenditure_item_date
15234: , params.sob_id
15235: ,nvl2(g_calculate_tax_flag, 'CREATE', null) --
15236: FROM po_line_locations_all adv,
15237: po_line_locations_all deliv,
15238: po_distributions_all pod
15239: WHERE adv.po_line_id = p_po_line_id
15240: AND adv.payment_type = 'ADVANCE'

Line 15237: po_line_locations_all deliv,

15233: , pod.expenditure_item_date
15234: , params.sob_id
15235: ,nvl2(g_calculate_tax_flag, 'CREATE', null) --
15236: FROM po_line_locations_all adv,
15237: po_line_locations_all deliv,
15238: po_distributions_all pod
15239: WHERE adv.po_line_id = p_po_line_id
15240: AND adv.payment_type = 'ADVANCE'
15241: AND deliv.line_location_id =

Line 15243: FROM po_line_locations_all poll

15239: WHERE adv.po_line_id = p_po_line_id
15240: AND adv.payment_type = 'ADVANCE'
15241: AND deliv.line_location_id =
15242: ( SELECT poll.line_location_id
15243: FROM po_line_locations_all poll
15244: WHERE poll.po_line_id = p_po_line_id
15245: AND poll.shipment_type = 'STANDARD'
15246: AND poll.shipment_num =
15247: ( SELECT min(poll2.shipment_num)

Line 15248: FROM po_line_locations_all poll2

15244: WHERE poll.po_line_id = p_po_line_id
15245: AND poll.shipment_type = 'STANDARD'
15246: AND poll.shipment_num =
15247: ( SELECT min(poll2.shipment_num)
15248: FROM po_line_locations_all poll2
15249: WHERE poll2.po_line_id = poll.po_line_id
15250: AND poll2.shipment_type = 'STANDARD'))
15251: AND pod.line_location_id = deliv.line_location_id;
15252:

Line 15266: FROM po_line_locations_all poll

15262: -- calibrate last distribution for each pay item
15263:
15264: SELECT poll.line_location_id, poll.value_basis
15265: BULK COLLECT INTO l_line_loc_id_tbl, l_line_loc_value_basis_tbl
15266: FROM po_line_locations_all poll
15267: WHERE poll.po_line_id = p_po_line_id;
15268:
15269: FOR i in 1..l_line_loc_id_tbl.COUNT
15270: LOOP