APPS.PO_LINES_SV4 dependencies on PO_DISTRIBUTIONS

Line 240: from po_distributions

236: if X_line_location_id is not null then
237:
238: select code_combination_id
239: into X_code_combination_id
240: from po_distributions
241: where line_location_id = X_line_location_id;
242:
243: X_num_of_dist := 1;
244:

Line 286: FROM PO_DISTRIBUTIONS_ALL POD

282:
283: --
284: SELECT sum(POD.quantity_ordered)
285: INTO X_encumbered_quantity
286: FROM PO_DISTRIBUTIONS_ALL POD
287: WHERE POD.po_line_id = X_po_line_id
288: AND POD.encumbered_flag = 'Y'
289: AND POD.distribution_type in ('STANDARD', 'PLANNED')
290: ;

Line 534: FROM po_distributions

530: X_progress := '170';
531:
532: SELECT COUNT(1)
533: INTO X_row_exists
534: FROM po_distributions
535: WHERE po_line_id = X_po_line_id
536: AND (destination_type_code in ('INVENTORY','SHOP FLOOR')
537: OR (destination_type_code = 'EXPENSE'
538: AND (X_expense_accrual_code = 'RECEIPT'

Line 556: FROM po_distributions

552: X_progress := '180';
553: -- Bug 3524527 : check for amounts on service lines
554: SELECT COUNT(1)
555: INTO X_row_exists
556: FROM po_distributions
557: WHERE po_line_id = X_po_line_id
558: AND (destination_type_code = 'EXPENSE'
559: AND (X_expense_accrual_code = 'RECEIPT'
560: OR X_amount_billed > 0))

Line 587: FROM po_distributions pod

583: X_row_exists := 0;
584:
585: SELECT COUNT(1)
586: INTO X_row_exists
587: FROM po_distributions pod
588: WHERE pod.po_Line_id = X_po_line_id
589: AND req_distribution_id is not null;
590:
591: IF X_row_exists > 0 THEN

Line 768: FROM po_distributions pod

764: x_progress := '010';
765:
766: SELECT COUNT(1)
767: INTO x_row_exists
768: FROM po_distributions pod
769: WHERE pod.po_line_id = X_po_line_id
770: AND req_distribution_id is not null;
771:
772: IF x_row_exists > 0 THEN