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.RCV_DISTRIBUTIONS_S dependencies on PO_DISTRIBUTIONS

Line 18: X_po_distributions_id OUT NOCOPY NUMBER,

14: (X_line_location_id IN NUMBER,
15: X_shipment_line_id IN NUMBER,
16: X_item_id IN NUMBER,
17: X_num_of_distributions IN OUT NOCOPY NUMBER,
18: X_po_distributions_id OUT NOCOPY NUMBER,
19: X_destination_type_code IN OUT NOCOPY VARCHAR2,
20: X_destination_type_dsp OUT NOCOPY VARCHAR2,
21: X_deliver_to_location_id IN OUT NOCOPY NUMBER,
22: X_deliver_to_location OUT NOCOPY VARCHAR2,

Line 58: l_code_combination_id PO_DISTRIBUTIONS.code_combination_id%TYPE;

54: X_valid_subinventory BOOLEAN;
55:
56: --
57: l_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
58: l_code_combination_id PO_DISTRIBUTIONS.code_combination_id%TYPE;
59: --
60:
61: /* Bug 3816908 : Variable added */
62: l_lookup_type po_lookup_codes.lookup_type%TYPE;

Line 64: x_project_id PO_DISTRIBUTIONS.project_id%type; -- bug 3867151

60:
61: /* Bug 3816908 : Variable added */
62: l_lookup_type po_lookup_codes.lookup_type%TYPE;
63:
64: x_project_id PO_DISTRIBUTIONS.project_id%type; -- bug 3867151
65: x_task_id PO_DISTRIBUTIONS.task_id%type; -- bug 3867151
66:
67: BEGIN
68:

Line 65: x_task_id PO_DISTRIBUTIONS.task_id%type; -- bug 3867151

61: /* Bug 3816908 : Variable added */
62: l_lookup_type po_lookup_codes.lookup_type%TYPE;
63:
64: x_project_id PO_DISTRIBUTIONS.project_id%type; -- bug 3867151
65: x_task_id PO_DISTRIBUTIONS.task_id%type; -- bug 3867151
66:
67: BEGIN
68:
69: X_progress := '010';

Line 76: FROM po_distributions

72: one or to just show multiple as the return value
73: */
74: SELECT count(po_distribution_id)
75: INTO X_num_of_distributions
76: FROM po_distributions
77: WHERE line_location_id = X_line_location_id;
78:
79:
80: /* If there are no distributions for this line_location_id then you

Line 91: from the po_distributions table

87: po_message_s.sql_error ('get_distribution_info', X_progress, SQLCODE);
88: RAISE NO_DATA_FOUND;
89:
90: /* If there is one distribution then go ahead and fetch the destination
91: from the po_distributions table
92: */
93: ELSIF X_num_of_distributions = 1 THEN
94:
95: X_progress := '020';

Line 121: INTO X_po_distributions_id,

117: mkc.kanban_card_number, --
118: pod.project_id, -- bug 3867151
119: pod.task_id, -- bug 3867151
120: pod.code_combination_id --
121: INTO X_po_distributions_id,
122: X_destination_type_code,
123: X_deliver_to_location_id,
124: X_deliver_to_location,
125: X_deliver_to_person_id,

Line 140: FROM po_distributions pod,

136: x_kanban_card_number, --
137: x_project_id, -- Bug 4684017 The variable should be x_project_id and not x_project_number
138: x_task_id, -- Bug 4684017 The variable should be x_project_id and not x_project_number
139: l_code_combination_id --
140: FROM po_distributions pod,
141: hr_locations_all_tl hl,
142: mtl_kanban_cards mkc --
143: WHERE pod.line_location_id = X_line_location_id
144: AND hl.location_id(+) = pod.deliver_to_location_id

Line 350: X_po_distributions_id NUMBER;

346: X_shipment_line_id IN NUMBER,
347: X_item_id IN NUMBER ) IS
348:
349: X_num_of_distributions NUMBER;
350: X_po_distributions_id NUMBER;
351: X_destination_type_code VARCHAR2(30);
352: X_destination_type_dsp VARCHAR2(80);
353: X_deliver_to_location_id NUMBER;
354:

Line 392: -- X_po_distributions_id, X_destination_type_code, X_destination_type_dsp,

388: NULL;
389: -- RCV_DISTRIBUTIONS_S.get_distributions_info
390: -- (X_line_location_id, X_shipment_line_id, X_item_id,
391: -- X_num_of_distributions,
392: -- X_po_distributions_id, X_destination_type_code, X_destination_type_dsp,
393: -- X_deliver_to_location_id, X_deliver_to_location,
394: -- X_deliver_to_person_id, X_deliver_to_person, X_deliver_to_sub,
395: -- X_deliver_to_locator_id, X_deliver_to_locator,X_wip_entity_id,
396: -- X_wip_repetitive_schedule_id,X_wip_line_id,X_wip_operation_seq_num ,

Line 412: to_char(X_po_distributions_id));

408: to_char(X_shipment_line_id));
409: dbms_output.put_line('Num of Dist: ' ||
410: to_char(X_num_of_distributions));
411: dbms_output.put_line('Dist ID: ' ||
412: to_char(X_po_distributions_id));
413: dbms_output.put_line('Dest Type Code: ' ||
414: X_destination_type_code);
415: dbms_output.put_line('Dest Type Dsp: ' ||
416: X_destination_type_dsp);

Line 464: * values in PO_LINE_LOCATIONS and PO_DISTRIBUTIONS

460:
461: /**
462: * Public Procedure: get_misc_distr_info
463: * Requires: p_line_location_id and p_po_distribution_id should be valid
464: * values in PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
465: * Modifies: None
466: * Effects: if p_line_location_id is given and po_distribution_id is NULL,
467: * then it returns distribution information (kanban_card_number,
468: * project_number, etc.) If there is only 1 distribution. If there

Line 536: l_wip_entity_id PO_DISTRIBUTIONS.wip_entity_id%TYPE;

532: --Bugfix5217513: Introduced Variables.
533: l_project_id NUMBER;
534: l_task_id NUMBER;
535:
536: l_wip_entity_id PO_DISTRIBUTIONS.wip_entity_id%TYPE;
537: l_wip_rep_schedule_id PO_DISTRIBUTIONS.wip_repetitive_schedule_id%TYPE;
538: l_wip_line_id PO_DISTRIBUTIONS.wip_line_id%TYPE;
539: l_wip_operation_seq_num PO_DISTRIBUTIONS.wip_operation_seq_num%TYPE;
540: l_wip_resource_seq_num PO_DISTRIBUTIONS.wip_resource_seq_num%TYPE;

Line 537: l_wip_rep_schedule_id PO_DISTRIBUTIONS.wip_repetitive_schedule_id%TYPE;

533: l_project_id NUMBER;
534: l_task_id NUMBER;
535:
536: l_wip_entity_id PO_DISTRIBUTIONS.wip_entity_id%TYPE;
537: l_wip_rep_schedule_id PO_DISTRIBUTIONS.wip_repetitive_schedule_id%TYPE;
538: l_wip_line_id PO_DISTRIBUTIONS.wip_line_id%TYPE;
539: l_wip_operation_seq_num PO_DISTRIBUTIONS.wip_operation_seq_num%TYPE;
540: l_wip_resource_seq_num PO_DISTRIBUTIONS.wip_resource_seq_num%TYPE;
541: l_to_organization_id PO_DISTRIBUTIONS.destination_organization_id%TYPE;

Line 538: l_wip_line_id PO_DISTRIBUTIONS.wip_line_id%TYPE;

534: l_task_id NUMBER;
535:
536: l_wip_entity_id PO_DISTRIBUTIONS.wip_entity_id%TYPE;
537: l_wip_rep_schedule_id PO_DISTRIBUTIONS.wip_repetitive_schedule_id%TYPE;
538: l_wip_line_id PO_DISTRIBUTIONS.wip_line_id%TYPE;
539: l_wip_operation_seq_num PO_DISTRIBUTIONS.wip_operation_seq_num%TYPE;
540: l_wip_resource_seq_num PO_DISTRIBUTIONS.wip_resource_seq_num%TYPE;
541: l_to_organization_id PO_DISTRIBUTIONS.destination_organization_id%TYPE;
542:

Line 539: l_wip_operation_seq_num PO_DISTRIBUTIONS.wip_operation_seq_num%TYPE;

535:
536: l_wip_entity_id PO_DISTRIBUTIONS.wip_entity_id%TYPE;
537: l_wip_rep_schedule_id PO_DISTRIBUTIONS.wip_repetitive_schedule_id%TYPE;
538: l_wip_line_id PO_DISTRIBUTIONS.wip_line_id%TYPE;
539: l_wip_operation_seq_num PO_DISTRIBUTIONS.wip_operation_seq_num%TYPE;
540: l_wip_resource_seq_num PO_DISTRIBUTIONS.wip_resource_seq_num%TYPE;
541: l_to_organization_id PO_DISTRIBUTIONS.destination_organization_id%TYPE;
542:
543: l_multi_distr VARCHAR2(1) := FND_API.G_FALSE;

Line 540: l_wip_resource_seq_num PO_DISTRIBUTIONS.wip_resource_seq_num%TYPE;

536: l_wip_entity_id PO_DISTRIBUTIONS.wip_entity_id%TYPE;
537: l_wip_rep_schedule_id PO_DISTRIBUTIONS.wip_repetitive_schedule_id%TYPE;
538: l_wip_line_id PO_DISTRIBUTIONS.wip_line_id%TYPE;
539: l_wip_operation_seq_num PO_DISTRIBUTIONS.wip_operation_seq_num%TYPE;
540: l_wip_resource_seq_num PO_DISTRIBUTIONS.wip_resource_seq_num%TYPE;
541: l_to_organization_id PO_DISTRIBUTIONS.destination_organization_id%TYPE;
542:
543: l_multi_distr VARCHAR2(1) := FND_API.G_FALSE;
544: l_multiple_msg VARCHAR2(2000);

Line 541: l_to_organization_id PO_DISTRIBUTIONS.destination_organization_id%TYPE;

537: l_wip_rep_schedule_id PO_DISTRIBUTIONS.wip_repetitive_schedule_id%TYPE;
538: l_wip_line_id PO_DISTRIBUTIONS.wip_line_id%TYPE;
539: l_wip_operation_seq_num PO_DISTRIBUTIONS.wip_operation_seq_num%TYPE;
540: l_wip_resource_seq_num PO_DISTRIBUTIONS.wip_resource_seq_num%TYPE;
541: l_to_organization_id PO_DISTRIBUTIONS.destination_organization_id%TYPE;
542:
543: l_multi_distr VARCHAR2(1) := FND_API.G_FALSE;
544: l_multiple_msg VARCHAR2(2000);
545:

Line 579: FROM po_distributions

575: l_num_jobs,
576: l_num_rates,
577: l_num_rate_dates,
578: l_num_dest_subinv
579: FROM po_distributions
580: WHERE line_location_id = p_line_location_id;
581:
582: IF (l_num_distributions > 1) THEN
583:

Line 664: FROM po_distributions POD,

660: l_wip_resource_seq_num,
661: l_to_organization_id,
662: x_rate,
663: x_rate_date
664: FROM po_distributions POD,
665: --pjm_projects_all_v PPA,
666: --pa_tasks_expend_v PTE,
667: mtl_kanban_cards MKC
668: WHERE POD.po_distribution_id = NVL(p_po_distribution_id,