APPS.PO_LINES_SV4 dependencies on PO_DISTRIBUTIONS

Line 245: from po_distributions

241: if X_line_location_id is not null then
242:
243: select code_combination_id
244: into X_code_combination_id
245: from po_distributions
246: where line_location_id = X_line_location_id;
247:
248: X_num_of_dist := 1;
249:

Line 291: FROM PO_DISTRIBUTIONS_ALL POD

287:
288: --
289: SELECT sum(POD.quantity_ordered)
290: INTO X_encumbered_quantity
291: FROM PO_DISTRIBUTIONS_ALL POD
292: WHERE POD.po_line_id = X_po_line_id
293: AND POD.encumbered_flag = 'Y'
294: AND POD.distribution_type in ('STANDARD', 'PLANNED')
295: ;

Line 539: FROM po_distributions

535: X_progress := '170';
536:
537: SELECT COUNT(1)
538: INTO X_row_exists
539: FROM po_distributions
540: WHERE po_line_id = X_po_line_id
541: AND (destination_type_code in ('INVENTORY','SHOP FLOOR')
542: OR (destination_type_code = 'EXPENSE'
543: AND (X_expense_accrual_code = 'RECEIPT'

Line 561: FROM po_distributions

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

Line 592: FROM po_distributions pod

588: X_row_exists := 0;
589:
590: SELECT COUNT(1)
591: INTO X_row_exists
592: FROM po_distributions pod
593: WHERE pod.po_Line_id = X_po_line_id
594: AND req_distribution_id is not null;
595:
596: IF X_row_exists > 0 THEN

Line 773: FROM po_distributions pod

769: x_progress := '010';
770:
771: SELECT COUNT(1)
772: INTO x_row_exists
773: FROM po_distributions pod
774: WHERE pod.po_line_id = X_po_line_id
775: AND req_distribution_id is not null;
776:
777: IF x_row_exists > 0 THEN