APPS.RCV_TRANSACTION_SV dependencies on PO_DISTRIBUTIONS

Line 27: l_code_combination_id PO_DISTRIBUTIONS.code_combination_id%TYPE;

23:
24: x_progress VARCHAR2(3) := NULL;
25:
26: --
27: l_code_combination_id PO_DISTRIBUTIONS.code_combination_id%TYPE;
28: --
29:
30: x_project_id PO_DISTRIBUTIONS.project_id%type; -- bug 5220069
31: x_task_id PO_DISTRIBUTIONS.task_id%type; -- bug 5220069

Line 30: x_project_id PO_DISTRIBUTIONS.project_id%type; -- bug 5220069

26: --
27: l_code_combination_id PO_DISTRIBUTIONS.code_combination_id%TYPE;
28: --
29:
30: x_project_id PO_DISTRIBUTIONS.project_id%type; -- bug 5220069
31: x_task_id PO_DISTRIBUTIONS.task_id%type; -- bug 5220069
32: begin
33: x_progress := 10;
34:

Line 31: x_task_id PO_DISTRIBUTIONS.task_id%type; -- bug 5220069

27: l_code_combination_id PO_DISTRIBUTIONS.code_combination_id%TYPE;
28: --
29:
30: x_project_id PO_DISTRIBUTIONS.project_id%type; -- bug 5220069
31: x_task_id PO_DISTRIBUTIONS.task_id%type; -- bug 5220069
32: begin
33: x_progress := 10;
34:
35: /* Bug 4753498: Replaced pa_tasks_expend_v with pa_tasks in following query */

Line 67: from po_distributions pod,

63: x_kanban_card_number, --
64: x_project_id, -- bug 5220069
65: x_task_id, -- bug 5220069
66: l_code_combination_id --
67: from po_distributions pod,
68: po_lookup_codes plc,
69: mtl_supply ms,
70: mtl_kanban_cards mkc --
71: where ms.supply_type_code = 'RECEIVING'

Line 279: from po_distributions

275:
276: if X_po_distribution_id is not null then
277: select destination_subinventory
278: into x_subinventory
279: from po_distributions
280: where po_distribution_id = X_po_distribution_id;
281:
282: -- Bug 3378162: for rma receipts, default subinventory from oe line.
283: elsif x_oe_order_line_id is not null then

Line 566: l_dest_subinv PO_DISTRIBUTIONS.destination_subinventory%TYPE;

562:
563:
564: --
565: l_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
566: l_dest_subinv PO_DISTRIBUTIONS.destination_subinventory%TYPE;
567: l_dummy_rate PO_DISTRIBUTIONS.rate%TYPE;
568: l_dummy_rate_date PO_DISTRIBUTIONS.rate_date%TYPE;
569: l_dummy_person HR_EMPLOYEES.full_name%TYPE;
570: l_dummy_subinv PO_REQUISITION_LINES.destination_subinventory%TYPE;

Line 567: l_dummy_rate PO_DISTRIBUTIONS.rate%TYPE;

563:
564: --
565: l_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
566: l_dest_subinv PO_DISTRIBUTIONS.destination_subinventory%TYPE;
567: l_dummy_rate PO_DISTRIBUTIONS.rate%TYPE;
568: l_dummy_rate_date PO_DISTRIBUTIONS.rate_date%TYPE;
569: l_dummy_person HR_EMPLOYEES.full_name%TYPE;
570: l_dummy_subinv PO_REQUISITION_LINES.destination_subinventory%TYPE;
571: --

Line 568: l_dummy_rate_date PO_DISTRIBUTIONS.rate_date%TYPE;

564: --
565: l_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
566: l_dest_subinv PO_DISTRIBUTIONS.destination_subinventory%TYPE;
567: l_dummy_rate PO_DISTRIBUTIONS.rate%TYPE;
568: l_dummy_rate_date PO_DISTRIBUTIONS.rate_date%TYPE;
569: l_dummy_person HR_EMPLOYEES.full_name%TYPE;
570: l_dummy_subinv PO_REQUISITION_LINES.destination_subinventory%TYPE;
571: --
572:

Line 868: from po_distributions

864: --retreive no_of_distributions for the shipment
865: x_progress := 115;
866: select count(*)
867: into x_count_po_distribution
868: from po_distributions
869: where line_location_id = x_po_line_location_id;
870:
871: end if;
872:

Line 938: FROM po_distributions

934: X_progress := '133';
935:
936: SELECT project_id, task_id
937: INTO X_project_id, X_task_id
938: FROM po_distributions
939: WHERE po_distribution_id = l_po_distribution_id;
940: END IF;
941:
942: ELSE

Line 1262: from po_distributions

1258: --retreive no_of_distributions for the shipment
1259: x_progress := 115;
1260: select count(*)
1261: into x_count_po_distribution
1262: from po_distributions
1263: where line_location_id = x_po_line_location_id;
1264:
1265: end if;
1266:

Line 1322: FROM po_distributions

1318: X_progress := '133';
1319:
1320: SELECT project_id, task_id
1321: INTO X_project_id, X_task_id
1322: FROM po_distributions
1323: WHERE po_distribution_id = l_po_distribution_id;
1324: END IF;
1325:
1326: ELSE