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 19: X_po_distributions_id OUT NOCOPY NUMBER,

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

Line 59: l_code_combination_id PO_DISTRIBUTIONS.code_combination_id%TYPE;

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

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

61:
62: /* Bug 3816908 : Variable added */
63: l_lookup_type po_lookup_codes.lookup_type%TYPE;
64:
65: x_project_id PO_DISTRIBUTIONS.project_id%type; -- bug 3867151
66: x_task_id PO_DISTRIBUTIONS.task_id%type; -- bug 3867151
67: l_clm_document VARCHAR2(1) := 'N'; -- Whether its a CLM document or Not
68:
69: l_asn_line_flag rcv_shipment_lines.asn_line_flag%TYPE ; -- bug 9742420

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

62: /* Bug 3816908 : Variable added */
63: l_lookup_type po_lookup_codes.lookup_type%TYPE;
64:
65: x_project_id PO_DISTRIBUTIONS.project_id%type; -- bug 3867151
66: x_task_id PO_DISTRIBUTIONS.task_id%type; -- bug 3867151
67: l_clm_document VARCHAR2(1) := 'N'; -- Whether its a CLM document or Not
68:
69: l_asn_line_flag rcv_shipment_lines.asn_line_flag%TYPE ; -- bug 9742420
70: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE; --bug 9742420

Line 70: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE; --bug 9742420

66: x_task_id PO_DISTRIBUTIONS.task_id%type; -- bug 3867151
67: l_clm_document VARCHAR2(1) := 'N'; -- Whether its a CLM document or Not
68:
69: l_asn_line_flag rcv_shipment_lines.asn_line_flag%TYPE ; -- bug 9742420
70: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE; --bug 9742420
71:
72: BEGIN
73:
74: X_progress := '010';

Line 81: FROM po_distributions

77: one or to just show multiple as the return value
78: */
79: SELECT count(po_distribution_id)
80: INTO X_num_of_distributions
81: FROM po_distributions
82: WHERE line_location_id = X_line_location_id;
83:
84: /* Bug 9742420 when asn receipt on multiple distribion,
85: each asn create one shipment line,

Line 98: IF X_po_distributions_id IS NULL THEN

94: FROM rcv_shipment_lines
95: WHERE shipment_line_id = X_SHIPMENT_LINE_ID ;
96:
97: IF l_asn_line_flag = 'Y' THEN
98: IF X_po_distributions_id IS NULL THEN
99: X_po_distributions_id := l_po_distribution_id;
100: END IF;
101:
102: IF X_po_distributions_id IS NOT NULL THEN

Line 99: X_po_distributions_id := l_po_distribution_id;

95: WHERE shipment_line_id = X_SHIPMENT_LINE_ID ;
96:
97: IF l_asn_line_flag = 'Y' THEN
98: IF X_po_distributions_id IS NULL THEN
99: X_po_distributions_id := l_po_distribution_id;
100: END IF;
101:
102: IF X_po_distributions_id IS NOT NULL THEN
103: X_num_of_distributions :=1 ;

Line 102: IF X_po_distributions_id IS NOT NULL THEN

98: IF X_po_distributions_id IS NULL THEN
99: X_po_distributions_id := l_po_distribution_id;
100: END IF;
101:
102: IF X_po_distributions_id IS NOT NULL THEN
103: X_num_of_distributions :=1 ;
104: END IF;
105: END IF;
106: END IF ;

Line 116: FROM po_distributions

112: SELECT 'Y' into l_clm_document
113: FROM po_headers_all h,
114: po_doc_style_headers s
115: WHERE h.po_header_id = ( SELECT MIN(PO_HEADER_ID)
116: FROM po_distributions
117: WHERE line_location_id = X_line_location_id
118: )
119: AND h.style_id = s.style_id
120: AND Nvl(s.clm_flag,'N') = 'Y';

Line 141: from the po_distributions table

137: RAISE NO_DATA_FOUND;
138: END IF;
139:
140: /* If there is one distribution then go ahead and fetch the destination
141: from the po_distributions table
142: */
143: ELSIF X_num_of_distributions = 1 THEN
144:
145: X_progress := '020';

Line 171: INTO X_po_distributions_id,

167: mkc.kanban_card_number, --
168: pod.project_id, -- bug 3867151
169: pod.task_id, -- bug 3867151
170: pod.code_combination_id --
171: INTO X_po_distributions_id,
172: X_destination_type_code,
173: X_deliver_to_location_id,
174: X_deliver_to_location,
175: X_deliver_to_person_id,

Line 190: FROM po_distributions pod,

186: x_kanban_card_number, --
187: x_project_id, -- Bug 4684017 The variable should be x_project_id and not x_project_number
188: x_task_id, -- Bug 4684017 The variable should be x_project_id and not x_project_number
189: l_code_combination_id --
190: FROM po_distributions pod,
191: hr_locations_all_tl hl,
192: mtl_kanban_cards mkc --
193: WHERE pod.line_location_id = X_line_location_id
194: AND pod.po_distribution_id = Nvl(X_PO_DISTRIBUTIONS_ID,pod.po_distribution_id) -- bug 9742420

Line 194: AND pod.po_distribution_id = Nvl(X_PO_DISTRIBUTIONS_ID,pod.po_distribution_id) -- bug 9742420

190: FROM po_distributions pod,
191: hr_locations_all_tl hl,
192: mtl_kanban_cards mkc --
193: WHERE pod.line_location_id = X_line_location_id
194: AND pod.po_distribution_id = Nvl(X_PO_DISTRIBUTIONS_ID,pod.po_distribution_id) -- bug 9742420
195: AND hl.location_id(+) = pod.deliver_to_location_id
196: AND hl.language(+) = USERENV('LANG')
197: AND pod.kanban_card_id = mkc.kanban_card_id (+); --
198:

Line 401: X_po_distributions_id NUMBER;

397: X_shipment_line_id IN NUMBER,
398: X_item_id IN NUMBER ) IS
399:
400: X_num_of_distributions NUMBER;
401: X_po_distributions_id NUMBER;
402: X_destination_type_code VARCHAR2(30);
403: X_destination_type_dsp VARCHAR2(80);
404: X_deliver_to_location_id NUMBER;
405:

Line 443: -- X_po_distributions_id, X_destination_type_code, X_destination_type_dsp,

439: NULL;
440: -- RCV_DISTRIBUTIONS_S.get_distributions_info
441: -- (X_line_location_id, X_shipment_line_id, X_item_id,
442: -- X_num_of_distributions,
443: -- X_po_distributions_id, X_destination_type_code, X_destination_type_dsp,
444: -- X_deliver_to_location_id, X_deliver_to_location,
445: -- X_deliver_to_person_id, X_deliver_to_person, X_deliver_to_sub,
446: -- X_deliver_to_locator_id, X_deliver_to_locator,X_wip_entity_id,
447: -- X_wip_repetitive_schedule_id,X_wip_line_id,X_wip_operation_seq_num ,

Line 463: to_char(X_po_distributions_id));

459: to_char(X_shipment_line_id));
460: dbms_output.put_line('Num of Dist: ' ||
461: to_char(X_num_of_distributions));
462: dbms_output.put_line('Dist ID: ' ||
463: to_char(X_po_distributions_id));
464: dbms_output.put_line('Dest Type Code: ' ||
465: X_destination_type_code);
466: dbms_output.put_line('Dest Type Dsp: ' ||
467: X_destination_type_dsp);

Line 515: * values in PO_LINE_LOCATIONS and PO_DISTRIBUTIONS

511:
512: /**
513: * Public Procedure: get_misc_distr_info
514: * Requires: p_line_location_id and p_po_distribution_id should be valid
515: * values in PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
516: * Modifies: None
517: * Effects: if p_line_location_id is given and po_distribution_id is NULL,
518: * then it returns distribution information (kanban_card_number,
519: * project_number, etc.) If there is only 1 distribution. If there

Line 587: l_wip_entity_id PO_DISTRIBUTIONS.wip_entity_id%TYPE;

583: --Bugfix5217513: Introduced Variables.
584: l_project_id NUMBER;
585: l_task_id NUMBER;
586:
587: l_wip_entity_id PO_DISTRIBUTIONS.wip_entity_id%TYPE;
588: l_wip_rep_schedule_id PO_DISTRIBUTIONS.wip_repetitive_schedule_id%TYPE;
589: l_wip_line_id PO_DISTRIBUTIONS.wip_line_id%TYPE;
590: l_wip_operation_seq_num PO_DISTRIBUTIONS.wip_operation_seq_num%TYPE;
591: l_wip_resource_seq_num PO_DISTRIBUTIONS.wip_resource_seq_num%TYPE;

Line 588: l_wip_rep_schedule_id PO_DISTRIBUTIONS.wip_repetitive_schedule_id%TYPE;

584: l_project_id NUMBER;
585: l_task_id NUMBER;
586:
587: l_wip_entity_id PO_DISTRIBUTIONS.wip_entity_id%TYPE;
588: l_wip_rep_schedule_id PO_DISTRIBUTIONS.wip_repetitive_schedule_id%TYPE;
589: l_wip_line_id PO_DISTRIBUTIONS.wip_line_id%TYPE;
590: l_wip_operation_seq_num PO_DISTRIBUTIONS.wip_operation_seq_num%TYPE;
591: l_wip_resource_seq_num PO_DISTRIBUTIONS.wip_resource_seq_num%TYPE;
592: l_to_organization_id PO_DISTRIBUTIONS.destination_organization_id%TYPE;

Line 589: l_wip_line_id PO_DISTRIBUTIONS.wip_line_id%TYPE;

585: l_task_id NUMBER;
586:
587: l_wip_entity_id PO_DISTRIBUTIONS.wip_entity_id%TYPE;
588: l_wip_rep_schedule_id PO_DISTRIBUTIONS.wip_repetitive_schedule_id%TYPE;
589: l_wip_line_id PO_DISTRIBUTIONS.wip_line_id%TYPE;
590: l_wip_operation_seq_num PO_DISTRIBUTIONS.wip_operation_seq_num%TYPE;
591: l_wip_resource_seq_num PO_DISTRIBUTIONS.wip_resource_seq_num%TYPE;
592: l_to_organization_id PO_DISTRIBUTIONS.destination_organization_id%TYPE;
593:

Line 590: l_wip_operation_seq_num PO_DISTRIBUTIONS.wip_operation_seq_num%TYPE;

586:
587: l_wip_entity_id PO_DISTRIBUTIONS.wip_entity_id%TYPE;
588: l_wip_rep_schedule_id PO_DISTRIBUTIONS.wip_repetitive_schedule_id%TYPE;
589: l_wip_line_id PO_DISTRIBUTIONS.wip_line_id%TYPE;
590: l_wip_operation_seq_num PO_DISTRIBUTIONS.wip_operation_seq_num%TYPE;
591: l_wip_resource_seq_num PO_DISTRIBUTIONS.wip_resource_seq_num%TYPE;
592: l_to_organization_id PO_DISTRIBUTIONS.destination_organization_id%TYPE;
593:
594: l_multi_distr VARCHAR2(1) := FND_API.G_FALSE;

Line 591: l_wip_resource_seq_num PO_DISTRIBUTIONS.wip_resource_seq_num%TYPE;

587: l_wip_entity_id PO_DISTRIBUTIONS.wip_entity_id%TYPE;
588: l_wip_rep_schedule_id PO_DISTRIBUTIONS.wip_repetitive_schedule_id%TYPE;
589: l_wip_line_id PO_DISTRIBUTIONS.wip_line_id%TYPE;
590: l_wip_operation_seq_num PO_DISTRIBUTIONS.wip_operation_seq_num%TYPE;
591: l_wip_resource_seq_num PO_DISTRIBUTIONS.wip_resource_seq_num%TYPE;
592: l_to_organization_id PO_DISTRIBUTIONS.destination_organization_id%TYPE;
593:
594: l_multi_distr VARCHAR2(1) := FND_API.G_FALSE;
595: l_multiple_msg VARCHAR2(2000);

Line 592: l_to_organization_id PO_DISTRIBUTIONS.destination_organization_id%TYPE;

588: l_wip_rep_schedule_id PO_DISTRIBUTIONS.wip_repetitive_schedule_id%TYPE;
589: l_wip_line_id PO_DISTRIBUTIONS.wip_line_id%TYPE;
590: l_wip_operation_seq_num PO_DISTRIBUTIONS.wip_operation_seq_num%TYPE;
591: l_wip_resource_seq_num PO_DISTRIBUTIONS.wip_resource_seq_num%TYPE;
592: l_to_organization_id PO_DISTRIBUTIONS.destination_organization_id%TYPE;
593:
594: l_multi_distr VARCHAR2(1) := FND_API.G_FALSE;
595: l_multiple_msg VARCHAR2(2000);
596:

Line 630: FROM po_distributions

626: l_num_jobs,
627: l_num_rates,
628: l_num_rate_dates,
629: l_num_dest_subinv
630: FROM po_distributions
631: WHERE line_location_id = p_line_location_id;
632:
633: IF (l_num_distributions > 1) THEN
634:

Line 715: FROM po_distributions_all POD, -- Bug 10203707

711: l_wip_resource_seq_num,
712: l_to_organization_id,
713: x_rate,
714: x_rate_date
715: FROM po_distributions_all POD, -- Bug 10203707
716: --pjm_projects_all_v PPA,
717: --pa_tasks_expend_v PTE,
718: mtl_kanban_cards MKC
719: WHERE POD.po_distribution_id = NVL(p_po_distribution_id,