APPS.POR_UTIL_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 4098: FROM po_distributions_all

4094: BEGIN
4095:
4096: SELECT po_line_id
4097: INTO l_po_line_id
4098: FROM po_distributions_all
4099: WHERE po_distribution_id = p_distribution_id ;
4100:
4101: -- Process further if the distribution has partial_funded_flag 'Y'.
4102: -- Return p_funded = -1, otherwise.

Line 4106: FROM po_distributions_all

4102: -- Return p_funded = -1, otherwise.
4103: BEGIN
4104: SELECT Nvl(partial_funded_flag,'N')
4105: INTO l_partial_funded_flag
4106: FROM po_distributions_all
4107: WHERE po_distribution_id = p_distribution_id ;
4108:
4109: IF l_partial_funded_flag = 'N' THEN
4110: p_funded := -1 ;

Line 4128: FROM po_distributions_all

4124:
4125: IF l_matching_basis = 'QUANTITY' THEN
4126: SELECT Round(Nvl(quantity_funded,0),15), Round(Nvl(quantity_funded,0) - Nvl(quantity_delivered,0),15)
4127: INTO p_funded, p_can_be_received
4128: FROM po_distributions_all
4129: WHERE po_distribution_id = p_distribution_id ;
4130: ELSE
4131: p_uom := NULL ;
4132:

Line 4135: FROM po_distributions_all

4131: p_uom := NULL ;
4132:
4133: SELECT Round(Nvl(amount_funded,0),15), Round(Nvl(amount_funded,0) - Nvl(amount_delivered,0),15)
4134: INTO p_funded, p_can_be_received
4135: FROM po_distributions_all
4136: WHERE po_distribution_id = p_distribution_id ;
4137: END IF ;
4138:
4139: EXCEPTION

Line 4297: SELECT destination_organization_id,wip_entity_id,wip_operation_seq_num,wip_resource_seq_num,wip_line_id,wip_repetitive_schedule_id,po_line_id FROM po_distributions_all

4293: FUNCTION validateWorkOrder(p_po_distribution_id IN number) RETURN NUMBER
4294: IS
4295:
4296: CURSOR c(x_po_distribution_id number) IS
4297: SELECT destination_organization_id,wip_entity_id,wip_operation_seq_num,wip_resource_seq_num,wip_line_id,wip_repetitive_schedule_id,po_line_id FROM po_distributions_all
4298: WHERE po_distribution_id = x_po_distribution_id;
4299: crec c%ROWTYPE;
4300: valid_wip_info NUMBER;
4301:

Line 4373: FROM WIP_DISCRETE_JOBS wdj, po_distributions_all pod

4369: x_progress := '000';
4370:
4371: if (x_dist_id IS NOT NULL) THEN
4372: SELECT DATE_RELEASED INTO X_JOB_RELEASED_DATE
4373: FROM WIP_DISCRETE_JOBS wdj, po_distributions_all pod
4374: WHERE wdj.ORGANIZATION_ID = pod.DESTINATION_ORGANIZATION_ID
4375: AND pod.wip_entity_id = wdj.wip_entity_id
4376: AND pod.po_distribution_id = x_dist_id;
4377:

Line 4420: FROM WIP_DISCRETE_JOBS wdj, po_distributions_all pod

4416: x_progress := '000';
4417:
4418: if (x_dist_id IS NOT NULL) THEN
4419: SELECT DATE_RELEASED INTO X_JOB_RELEASED_DATE
4420: FROM WIP_DISCRETE_JOBS wdj, po_distributions_all pod
4421: WHERE wdj.ORGANIZATION_ID = pod.DESTINATION_ORGANIZATION_ID
4422: AND pod.wip_entity_id = wdj.wip_entity_id
4423: AND pod.po_distribution_id = x_dist_id;
4424:

Line 4468: SELECT PROJECT_ID INTO x_pjt_id FROM po_distributions_all WHERE PO_DISTRIBUTION_ID = x_dist_id;

4464: result := 0;
4465: x_progress := '000';
4466:
4467: if (x_dist_id IS NOT NULL) THEN
4468: SELECT PROJECT_ID INTO x_pjt_id FROM po_distributions_all WHERE PO_DISTRIBUTION_ID = x_dist_id;
4469: if (x_pjt_id IS NOT NULL) THEN
4470: BEGIN
4471: SELECT DISTINCT project_id INTO x_pjt_id_dummy from(
4472: SELECT project_id

Line 4527: SELECT PROJECT_ID INTO x_pjt_id FROM po_distributions_all WHERE PO_DISTRIBUTION_ID = p_po_dist_id;

4523:
4524: x_progress := '000';
4525:
4526: if (p_po_dist_id IS NOT NULL) THEN
4527: SELECT PROJECT_ID INTO x_pjt_id FROM po_distributions_all WHERE PO_DISTRIBUTION_ID = p_po_dist_id;
4528:
4529: if (x_pjt_id IS NOT NULL) THEN
4530: BEGIN
4531: SELECT NAME INTO x_pjt_name FROM PA_PROJECTS_ALL WHERE project_id = x_pjt_id;