DBA Data[Home] [Help]

APPS.PO_ASL_API_PUB dependencies on CHV_BUCKET_PATTERNS

Line 1704: FROM chv_bucket_patterns cbp

1700:
1701: UPDATE po_asl_attributes_gt paa
1702: SET paa.plan_bucket_pattern_id =
1703: (SELECT cbp.bucket_pattern_id
1704: FROM chv_bucket_patterns cbp
1705: WHERE cbp.bucket_pattern_name = paa.plan_bucket_pattern_dsp
1706: AND ROWNUM < 2)
1707: WHERE paa.plan_bucket_pattern_dsp IS NOT NULL;
1708: l_progress := 30;

Line 1713: FROM chv_bucket_patterns cbp

1709:
1710: UPDATE po_asl_attributes_gt paa
1711: SET paa.ship_bucket_pattern_id =
1712: (SELECT cbp.bucket_pattern_id
1713: FROM chv_bucket_patterns cbp
1714: WHERE cbp.bucket_pattern_name = paa.ship_bucket_pattern_dsp
1715: AND ROWNUM < 2)
1716: WHERE paa.ship_bucket_pattern_dsp IS NOT NULL;
1717: l_progress := 35;