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 302: from po_distributions

298:
299: if X_po_distribution_id is not null then
300: select destination_subinventory
301: into x_subinventory
302: from po_distributions
303: where po_distribution_id = X_po_distribution_id;
304:
305: -- Bug 3378162: for rma receipts, default subinventory from oe line.
306: elsif x_oe_order_line_id is not null then

Line 593: l_dest_subinv PO_DISTRIBUTIONS.destination_subinventory%TYPE;

589:
590:
591: --
592: l_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
593: l_dest_subinv PO_DISTRIBUTIONS.destination_subinventory%TYPE;
594: l_dummy_rate PO_DISTRIBUTIONS.rate%TYPE;
595: l_dummy_rate_date PO_DISTRIBUTIONS.rate_date%TYPE;
596: l_dummy_person HR_EMPLOYEES.full_name%TYPE;
597: l_dummy_subinv PO_REQUISITION_LINES.destination_subinventory%TYPE;

Line 594: l_dummy_rate PO_DISTRIBUTIONS.rate%TYPE;

590:
591: --
592: l_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
593: l_dest_subinv PO_DISTRIBUTIONS.destination_subinventory%TYPE;
594: l_dummy_rate PO_DISTRIBUTIONS.rate%TYPE;
595: l_dummy_rate_date PO_DISTRIBUTIONS.rate_date%TYPE;
596: l_dummy_person HR_EMPLOYEES.full_name%TYPE;
597: l_dummy_subinv PO_REQUISITION_LINES.destination_subinventory%TYPE;
598: --

Line 595: l_dummy_rate_date PO_DISTRIBUTIONS.rate_date%TYPE;

591: --
592: l_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
593: l_dest_subinv PO_DISTRIBUTIONS.destination_subinventory%TYPE;
594: l_dummy_rate PO_DISTRIBUTIONS.rate%TYPE;
595: l_dummy_rate_date PO_DISTRIBUTIONS.rate_date%TYPE;
596: l_dummy_person HR_EMPLOYEES.full_name%TYPE;
597: l_dummy_subinv PO_REQUISITION_LINES.destination_subinventory%TYPE;
598: --
599:

Line 895: from po_distributions

891: --retreive no_of_distributions for the shipment
892: x_progress := 115;
893: select count(*)
894: into x_count_po_distribution
895: from po_distributions
896: where line_location_id = x_po_line_location_id;
897:
898: end if;
899:

Line 965: FROM po_distributions

961: X_progress := '133';
962:
963: SELECT project_id, task_id
964: INTO X_project_id, X_task_id
965: FROM po_distributions
966: WHERE po_distribution_id = l_po_distribution_id;
967: END IF;
968:
969: ELSE

Line 1289: from po_distributions

1285: --retreive no_of_distributions for the shipment
1286: x_progress := 115;
1287: select count(*)
1288: into x_count_po_distribution
1289: from po_distributions
1290: where line_location_id = x_po_line_location_id;
1291:
1292: end if;
1293:

Line 1349: FROM po_distributions

1345: X_progress := '133';
1346:
1347: SELECT project_id, task_id
1348: INTO X_project_id, X_task_id
1349: FROM po_distributions
1350: WHERE po_distribution_id = l_po_distribution_id;
1351: END IF;
1352:
1353: ELSE