DBA Data[Home] [Help]

APPS.WIP_DISCRETEJOB_UTIL dependencies on WIP_GLOBALS

Line 1908: IF WIP_GLOBALS.Equal(p_DiscreteJob_rec.alternate_bom_designator,

1904: FOR UPDATE NOWAIT;
1905:
1906: -- Row locked. Compare IN attributes to DB attributes.
1907:
1908: IF WIP_GLOBALS.Equal(p_DiscreteJob_rec.alternate_bom_designator,
1909: l_DiscreteJob_rec.alternate_bom_designator)
1910: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.alternate_rout_designator,
1911: l_DiscreteJob_rec.alternate_rout_designator)
1912: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute1,

Line 1910: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.alternate_rout_designator,

1906: -- Row locked. Compare IN attributes to DB attributes.
1907:
1908: IF WIP_GLOBALS.Equal(p_DiscreteJob_rec.alternate_bom_designator,
1909: l_DiscreteJob_rec.alternate_bom_designator)
1910: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.alternate_rout_designator,
1911: l_DiscreteJob_rec.alternate_rout_designator)
1912: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute1,
1913: l_DiscreteJob_rec.attribute1)
1914: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute10,

Line 1912: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute1,

1908: IF WIP_GLOBALS.Equal(p_DiscreteJob_rec.alternate_bom_designator,
1909: l_DiscreteJob_rec.alternate_bom_designator)
1910: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.alternate_rout_designator,
1911: l_DiscreteJob_rec.alternate_rout_designator)
1912: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute1,
1913: l_DiscreteJob_rec.attribute1)
1914: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute10,
1915: l_DiscreteJob_rec.attribute10)
1916: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute11,

Line 1914: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute10,

1910: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.alternate_rout_designator,
1911: l_DiscreteJob_rec.alternate_rout_designator)
1912: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute1,
1913: l_DiscreteJob_rec.attribute1)
1914: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute10,
1915: l_DiscreteJob_rec.attribute10)
1916: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute11,
1917: l_DiscreteJob_rec.attribute11)
1918: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute12,

Line 1916: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute11,

1912: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute1,
1913: l_DiscreteJob_rec.attribute1)
1914: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute10,
1915: l_DiscreteJob_rec.attribute10)
1916: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute11,
1917: l_DiscreteJob_rec.attribute11)
1918: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute12,
1919: l_DiscreteJob_rec.attribute12)
1920: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute13,

Line 1918: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute12,

1914: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute10,
1915: l_DiscreteJob_rec.attribute10)
1916: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute11,
1917: l_DiscreteJob_rec.attribute11)
1918: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute12,
1919: l_DiscreteJob_rec.attribute12)
1920: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute13,
1921: l_DiscreteJob_rec.attribute13)
1922: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute14,

Line 1920: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute13,

1916: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute11,
1917: l_DiscreteJob_rec.attribute11)
1918: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute12,
1919: l_DiscreteJob_rec.attribute12)
1920: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute13,
1921: l_DiscreteJob_rec.attribute13)
1922: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute14,
1923: l_DiscreteJob_rec.attribute14)
1924: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute15,

Line 1922: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute14,

1918: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute12,
1919: l_DiscreteJob_rec.attribute12)
1920: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute13,
1921: l_DiscreteJob_rec.attribute13)
1922: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute14,
1923: l_DiscreteJob_rec.attribute14)
1924: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute15,
1925: l_DiscreteJob_rec.attribute15)
1926: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute2,

Line 1924: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute15,

1920: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute13,
1921: l_DiscreteJob_rec.attribute13)
1922: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute14,
1923: l_DiscreteJob_rec.attribute14)
1924: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute15,
1925: l_DiscreteJob_rec.attribute15)
1926: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute2,
1927: l_DiscreteJob_rec.attribute2)
1928: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute3,

Line 1926: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute2,

1922: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute14,
1923: l_DiscreteJob_rec.attribute14)
1924: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute15,
1925: l_DiscreteJob_rec.attribute15)
1926: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute2,
1927: l_DiscreteJob_rec.attribute2)
1928: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute3,
1929: l_DiscreteJob_rec.attribute3)
1930: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute4,

Line 1928: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute3,

1924: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute15,
1925: l_DiscreteJob_rec.attribute15)
1926: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute2,
1927: l_DiscreteJob_rec.attribute2)
1928: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute3,
1929: l_DiscreteJob_rec.attribute3)
1930: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute4,
1931: l_DiscreteJob_rec.attribute4)
1932: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute5,

Line 1930: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute4,

1926: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute2,
1927: l_DiscreteJob_rec.attribute2)
1928: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute3,
1929: l_DiscreteJob_rec.attribute3)
1930: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute4,
1931: l_DiscreteJob_rec.attribute4)
1932: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute5,
1933: l_DiscreteJob_rec.attribute5)
1934: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute6,

Line 1932: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute5,

1928: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute3,
1929: l_DiscreteJob_rec.attribute3)
1930: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute4,
1931: l_DiscreteJob_rec.attribute4)
1932: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute5,
1933: l_DiscreteJob_rec.attribute5)
1934: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute6,
1935: l_DiscreteJob_rec.attribute6)
1936: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute7,

Line 1934: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute6,

1930: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute4,
1931: l_DiscreteJob_rec.attribute4)
1932: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute5,
1933: l_DiscreteJob_rec.attribute5)
1934: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute6,
1935: l_DiscreteJob_rec.attribute6)
1936: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute7,
1937: l_DiscreteJob_rec.attribute7)
1938: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute8,

Line 1936: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute7,

1932: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute5,
1933: l_DiscreteJob_rec.attribute5)
1934: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute6,
1935: l_DiscreteJob_rec.attribute6)
1936: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute7,
1937: l_DiscreteJob_rec.attribute7)
1938: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute8,
1939: l_DiscreteJob_rec.attribute8)
1940: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute9,

Line 1938: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute8,

1934: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute6,
1935: l_DiscreteJob_rec.attribute6)
1936: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute7,
1937: l_DiscreteJob_rec.attribute7)
1938: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute8,
1939: l_DiscreteJob_rec.attribute8)
1940: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute9,
1941: l_DiscreteJob_rec.attribute9)
1942: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute_category,

Line 1940: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute9,

1936: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute7,
1937: l_DiscreteJob_rec.attribute7)
1938: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute8,
1939: l_DiscreteJob_rec.attribute8)
1940: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute9,
1941: l_DiscreteJob_rec.attribute9)
1942: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute_category,
1943: l_DiscreteJob_rec.attribute_category)
1944: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_reference_id,

Line 1942: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute_category,

1938: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute8,
1939: l_DiscreteJob_rec.attribute8)
1940: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute9,
1941: l_DiscreteJob_rec.attribute9)
1942: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute_category,
1943: l_DiscreteJob_rec.attribute_category)
1944: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_reference_id,
1945: l_DiscreteJob_rec.bom_reference_id)
1946: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision,

Line 1944: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_reference_id,

1940: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute9,
1941: l_DiscreteJob_rec.attribute9)
1942: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute_category,
1943: l_DiscreteJob_rec.attribute_category)
1944: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_reference_id,
1945: l_DiscreteJob_rec.bom_reference_id)
1946: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision,
1947: l_DiscreteJob_rec.bom_revision)
1948: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision_date,

Line 1946: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision,

1942: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute_category,
1943: l_DiscreteJob_rec.attribute_category)
1944: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_reference_id,
1945: l_DiscreteJob_rec.bom_reference_id)
1946: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision,
1947: l_DiscreteJob_rec.bom_revision)
1948: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision_date,
1949: l_DiscreteJob_rec.bom_revision_date)
1950: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.build_sequence,

Line 1948: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision_date,

1944: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_reference_id,
1945: l_DiscreteJob_rec.bom_reference_id)
1946: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision,
1947: l_DiscreteJob_rec.bom_revision)
1948: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision_date,
1949: l_DiscreteJob_rec.bom_revision_date)
1950: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.build_sequence,
1951: l_DiscreteJob_rec.build_sequence)
1952: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.class_code,

Line 1950: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.build_sequence,

1946: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision,
1947: l_DiscreteJob_rec.bom_revision)
1948: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision_date,
1949: l_DiscreteJob_rec.bom_revision_date)
1950: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.build_sequence,
1951: l_DiscreteJob_rec.build_sequence)
1952: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.class_code,
1953: l_DiscreteJob_rec.class_code)
1954: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_bom_sequence_id,

Line 1952: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.class_code,

1948: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision_date,
1949: l_DiscreteJob_rec.bom_revision_date)
1950: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.build_sequence,
1951: l_DiscreteJob_rec.build_sequence)
1952: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.class_code,
1953: l_DiscreteJob_rec.class_code)
1954: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_bom_sequence_id,
1955: l_DiscreteJob_rec.common_bom_sequence_id)
1956: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_rout_sequence_id,

Line 1954: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_bom_sequence_id,

1950: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.build_sequence,
1951: l_DiscreteJob_rec.build_sequence)
1952: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.class_code,
1953: l_DiscreteJob_rec.class_code)
1954: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_bom_sequence_id,
1955: l_DiscreteJob_rec.common_bom_sequence_id)
1956: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_rout_sequence_id,
1957: l_DiscreteJob_rec.common_rout_sequence_id)
1958: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_locator_id,

Line 1956: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_rout_sequence_id,

1952: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.class_code,
1953: l_DiscreteJob_rec.class_code)
1954: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_bom_sequence_id,
1955: l_DiscreteJob_rec.common_bom_sequence_id)
1956: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_rout_sequence_id,
1957: l_DiscreteJob_rec.common_rout_sequence_id)
1958: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_locator_id,
1959: l_DiscreteJob_rec.completion_locator_id)
1960: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_subinventory,

Line 1958: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_locator_id,

1954: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_bom_sequence_id,
1955: l_DiscreteJob_rec.common_bom_sequence_id)
1956: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_rout_sequence_id,
1957: l_DiscreteJob_rec.common_rout_sequence_id)
1958: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_locator_id,
1959: l_DiscreteJob_rec.completion_locator_id)
1960: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_subinventory,
1961: l_DiscreteJob_rec.completion_subinventory)
1962: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.created_by,

Line 1960: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_subinventory,

1956: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_rout_sequence_id,
1957: l_DiscreteJob_rec.common_rout_sequence_id)
1958: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_locator_id,
1959: l_DiscreteJob_rec.completion_locator_id)
1960: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_subinventory,
1961: l_DiscreteJob_rec.completion_subinventory)
1962: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.created_by,
1963: l_DiscreteJob_rec.created_by)
1964: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.creation_date,

Line 1962: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.created_by,

1958: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_locator_id,
1959: l_DiscreteJob_rec.completion_locator_id)
1960: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_subinventory,
1961: l_DiscreteJob_rec.completion_subinventory)
1962: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.created_by,
1963: l_DiscreteJob_rec.created_by)
1964: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.creation_date,
1965: l_DiscreteJob_rec.creation_date)
1966: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_closed,

Line 1964: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.creation_date,

1960: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_subinventory,
1961: l_DiscreteJob_rec.completion_subinventory)
1962: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.created_by,
1963: l_DiscreteJob_rec.created_by)
1964: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.creation_date,
1965: l_DiscreteJob_rec.creation_date)
1966: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_closed,
1967: l_DiscreteJob_rec.date_closed)
1968: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_completed,

Line 1966: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_closed,

1962: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.created_by,
1963: l_DiscreteJob_rec.created_by)
1964: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.creation_date,
1965: l_DiscreteJob_rec.creation_date)
1966: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_closed,
1967: l_DiscreteJob_rec.date_closed)
1968: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_completed,
1969: l_DiscreteJob_rec.date_completed)
1970: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_released,

Line 1968: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_completed,

1964: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.creation_date,
1965: l_DiscreteJob_rec.creation_date)
1966: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_closed,
1967: l_DiscreteJob_rec.date_closed)
1968: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_completed,
1969: l_DiscreteJob_rec.date_completed)
1970: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_released,
1971: l_DiscreteJob_rec.date_released)
1972: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.demand_class,

Line 1970: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_released,

1966: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_closed,
1967: l_DiscreteJob_rec.date_closed)
1968: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_completed,
1969: l_DiscreteJob_rec.date_completed)
1970: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_released,
1971: l_DiscreteJob_rec.date_released)
1972: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.demand_class,
1973: l_DiscreteJob_rec.demand_class)
1974: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.description,

Line 1972: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.demand_class,

1968: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_completed,
1969: l_DiscreteJob_rec.date_completed)
1970: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_released,
1971: l_DiscreteJob_rec.date_released)
1972: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.demand_class,
1973: l_DiscreteJob_rec.demand_class)
1974: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.description,
1975: l_DiscreteJob_rec.description)
1976: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.firm_planned_flag,

Line 1974: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.description,

1970: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_released,
1971: l_DiscreteJob_rec.date_released)
1972: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.demand_class,
1973: l_DiscreteJob_rec.demand_class)
1974: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.description,
1975: l_DiscreteJob_rec.description)
1976: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.firm_planned_flag,
1977: l_DiscreteJob_rec.firm_planned_flag)
1978: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.job_type,

Line 1976: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.firm_planned_flag,

1972: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.demand_class,
1973: l_DiscreteJob_rec.demand_class)
1974: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.description,
1975: l_DiscreteJob_rec.description)
1976: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.firm_planned_flag,
1977: l_DiscreteJob_rec.firm_planned_flag)
1978: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.job_type,
1979: l_DiscreteJob_rec.job_type)
1980: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.kanban_card_id,

Line 1978: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.job_type,

1974: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.description,
1975: l_DiscreteJob_rec.description)
1976: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.firm_planned_flag,
1977: l_DiscreteJob_rec.firm_planned_flag)
1978: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.job_type,
1979: l_DiscreteJob_rec.job_type)
1980: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.kanban_card_id,
1981: l_DiscreteJob_rec.kanban_card_id)
1982: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_updated_by,

Line 1980: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.kanban_card_id,

1976: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.firm_planned_flag,
1977: l_DiscreteJob_rec.firm_planned_flag)
1978: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.job_type,
1979: l_DiscreteJob_rec.job_type)
1980: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.kanban_card_id,
1981: l_DiscreteJob_rec.kanban_card_id)
1982: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_updated_by,
1983: l_DiscreteJob_rec.last_updated_by)
1984: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_date,

Line 1982: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_updated_by,

1978: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.job_type,
1979: l_DiscreteJob_rec.job_type)
1980: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.kanban_card_id,
1981: l_DiscreteJob_rec.kanban_card_id)
1982: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_updated_by,
1983: l_DiscreteJob_rec.last_updated_by)
1984: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_date,
1985: l_DiscreteJob_rec.last_update_date)
1986: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_login,

Line 1984: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_date,

1980: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.kanban_card_id,
1981: l_DiscreteJob_rec.kanban_card_id)
1982: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_updated_by,
1983: l_DiscreteJob_rec.last_updated_by)
1984: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_date,
1985: l_DiscreteJob_rec.last_update_date)
1986: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_login,
1987: l_DiscreteJob_rec.last_update_login)
1988: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.line_id,

Line 1986: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_login,

1982: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_updated_by,
1983: l_DiscreteJob_rec.last_updated_by)
1984: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_date,
1985: l_DiscreteJob_rec.last_update_date)
1986: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_login,
1987: l_DiscreteJob_rec.last_update_login)
1988: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.line_id,
1989: l_DiscreteJob_rec.line_id)
1990: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.lot_number,

Line 1988: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.line_id,

1984: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_date,
1985: l_DiscreteJob_rec.last_update_date)
1986: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_login,
1987: l_DiscreteJob_rec.last_update_login)
1988: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.line_id,
1989: l_DiscreteJob_rec.line_id)
1990: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.lot_number,
1991: l_DiscreteJob_rec.lot_number)
1992: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_account,

Line 1990: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.lot_number,

1986: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_login,
1987: l_DiscreteJob_rec.last_update_login)
1988: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.line_id,
1989: l_DiscreteJob_rec.line_id)
1990: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.lot_number,
1991: l_DiscreteJob_rec.lot_number)
1992: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_account,
1993: l_DiscreteJob_rec.material_account)
1994: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_overhead_account,

Line 1992: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_account,

1988: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.line_id,
1989: l_DiscreteJob_rec.line_id)
1990: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.lot_number,
1991: l_DiscreteJob_rec.lot_number)
1992: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_account,
1993: l_DiscreteJob_rec.material_account)
1994: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_overhead_account,
1995: l_DiscreteJob_rec.material_overhead_account)
1996: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_variance_account,

Line 1994: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_overhead_account,

1990: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.lot_number,
1991: l_DiscreteJob_rec.lot_number)
1992: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_account,
1993: l_DiscreteJob_rec.material_account)
1994: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_overhead_account,
1995: l_DiscreteJob_rec.material_overhead_account)
1996: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_variance_account,
1997: l_DiscreteJob_rec.material_variance_account)
1998: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_net_quantity,

Line 1996: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_variance_account,

1992: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_account,
1993: l_DiscreteJob_rec.material_account)
1994: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_overhead_account,
1995: l_DiscreteJob_rec.material_overhead_account)
1996: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_variance_account,
1997: l_DiscreteJob_rec.material_variance_account)
1998: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_net_quantity,
1999: l_DiscreteJob_rec.mps_net_quantity)
2000: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_scheduled_cpl_date,

Line 1998: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_net_quantity,

1994: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_overhead_account,
1995: l_DiscreteJob_rec.material_overhead_account)
1996: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_variance_account,
1997: l_DiscreteJob_rec.material_variance_account)
1998: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_net_quantity,
1999: l_DiscreteJob_rec.mps_net_quantity)
2000: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_scheduled_cpl_date,
2001: l_DiscreteJob_rec.mps_scheduled_cpl_date)
2002: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.net_quantity,

Line 2000: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_scheduled_cpl_date,

1996: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_variance_account,
1997: l_DiscreteJob_rec.material_variance_account)
1998: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_net_quantity,
1999: l_DiscreteJob_rec.mps_net_quantity)
2000: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_scheduled_cpl_date,
2001: l_DiscreteJob_rec.mps_scheduled_cpl_date)
2002: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.net_quantity,
2003: l_DiscreteJob_rec.net_quantity)
2004: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.organization_id,

Line 2002: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.net_quantity,

1998: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_net_quantity,
1999: l_DiscreteJob_rec.mps_net_quantity)
2000: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_scheduled_cpl_date,
2001: l_DiscreteJob_rec.mps_scheduled_cpl_date)
2002: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.net_quantity,
2003: l_DiscreteJob_rec.net_quantity)
2004: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.organization_id,
2005: l_DiscreteJob_rec.organization_id)
2006: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_account,

Line 2004: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.organization_id,

2000: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_scheduled_cpl_date,
2001: l_DiscreteJob_rec.mps_scheduled_cpl_date)
2002: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.net_quantity,
2003: l_DiscreteJob_rec.net_quantity)
2004: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.organization_id,
2005: l_DiscreteJob_rec.organization_id)
2006: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_account,
2007: l_DiscreteJob_rec.osp_account)
2008: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_variance_account,

Line 2006: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_account,

2002: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.net_quantity,
2003: l_DiscreteJob_rec.net_quantity)
2004: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.organization_id,
2005: l_DiscreteJob_rec.organization_id)
2006: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_account,
2007: l_DiscreteJob_rec.osp_account)
2008: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_variance_account,
2009: l_DiscreteJob_rec.osp_variance_account)
2010: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_type,

Line 2008: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_variance_account,

2004: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.organization_id,
2005: l_DiscreteJob_rec.organization_id)
2006: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_account,
2007: l_DiscreteJob_rec.osp_account)
2008: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_variance_account,
2009: l_DiscreteJob_rec.osp_variance_account)
2010: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_type,
2011: l_DiscreteJob_rec.overcpl_tolerance_type)
2012: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_value,

Line 2010: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_type,

2006: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_account,
2007: l_DiscreteJob_rec.osp_account)
2008: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_variance_account,
2009: l_DiscreteJob_rec.osp_variance_account)
2010: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_type,
2011: l_DiscreteJob_rec.overcpl_tolerance_type)
2012: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_value,
2013: l_DiscreteJob_rec.overcpl_tolerance_value)
2014: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_account,

Line 2012: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_value,

2008: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_variance_account,
2009: l_DiscreteJob_rec.osp_variance_account)
2010: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_type,
2011: l_DiscreteJob_rec.overcpl_tolerance_type)
2012: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_value,
2013: l_DiscreteJob_rec.overcpl_tolerance_value)
2014: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_account,
2015: l_DiscreteJob_rec.overhead_account)
2016: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_variance_account,

Line 2014: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_account,

2010: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_type,
2011: l_DiscreteJob_rec.overcpl_tolerance_type)
2012: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_value,
2013: l_DiscreteJob_rec.overcpl_tolerance_value)
2014: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_account,
2015: l_DiscreteJob_rec.overhead_account)
2016: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_variance_account,
2017: l_DiscreteJob_rec.overhead_variance_account)
2018: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.primary_item_id,

Line 2016: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_variance_account,

2012: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_value,
2013: l_DiscreteJob_rec.overcpl_tolerance_value)
2014: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_account,
2015: l_DiscreteJob_rec.overhead_account)
2016: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_variance_account,
2017: l_DiscreteJob_rec.overhead_variance_account)
2018: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.primary_item_id,
2019: l_DiscreteJob_rec.primary_item_id)
2020: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_application_id,

Line 2018: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.primary_item_id,

2014: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_account,
2015: l_DiscreteJob_rec.overhead_account)
2016: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_variance_account,
2017: l_DiscreteJob_rec.overhead_variance_account)
2018: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.primary_item_id,
2019: l_DiscreteJob_rec.primary_item_id)
2020: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_application_id,
2021: l_DiscreteJob_rec.program_application_id)
2022: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_id,

Line 2020: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_application_id,

2016: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_variance_account,
2017: l_DiscreteJob_rec.overhead_variance_account)
2018: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.primary_item_id,
2019: l_DiscreteJob_rec.primary_item_id)
2020: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_application_id,
2021: l_DiscreteJob_rec.program_application_id)
2022: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_id,
2023: l_DiscreteJob_rec.program_id)
2024: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_update_date,

Line 2022: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_id,

2018: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.primary_item_id,
2019: l_DiscreteJob_rec.primary_item_id)
2020: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_application_id,
2021: l_DiscreteJob_rec.program_application_id)
2022: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_id,
2023: l_DiscreteJob_rec.program_id)
2024: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_update_date,
2025: l_DiscreteJob_rec.program_update_date)
2026: -- AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_costed,

Line 2024: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_update_date,

2020: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_application_id,
2021: l_DiscreteJob_rec.program_application_id)
2022: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_id,
2023: l_DiscreteJob_rec.program_id)
2024: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_update_date,
2025: l_DiscreteJob_rec.program_update_date)
2026: -- AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_costed,
2027: -- l_DiscreteJob_rec.project_costed)
2028: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_id,

Line 2026: -- AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_costed,

2022: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_id,
2023: l_DiscreteJob_rec.program_id)
2024: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_update_date,
2025: l_DiscreteJob_rec.program_update_date)
2026: -- AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_costed,
2027: -- l_DiscreteJob_rec.project_costed)
2028: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_id,
2029: l_DiscreteJob_rec.project_id)
2030: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_completed,

Line 2028: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_id,

2024: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_update_date,
2025: l_DiscreteJob_rec.program_update_date)
2026: -- AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_costed,
2027: -- l_DiscreteJob_rec.project_costed)
2028: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_id,
2029: l_DiscreteJob_rec.project_id)
2030: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_completed,
2031: l_DiscreteJob_rec.quantity_completed)
2032: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_scrapped,

Line 2030: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_completed,

2026: -- AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_costed,
2027: -- l_DiscreteJob_rec.project_costed)
2028: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_id,
2029: l_DiscreteJob_rec.project_id)
2030: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_completed,
2031: l_DiscreteJob_rec.quantity_completed)
2032: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_scrapped,
2033: l_DiscreteJob_rec.quantity_scrapped)
2034: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.request_id,

Line 2032: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_scrapped,

2028: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_id,
2029: l_DiscreteJob_rec.project_id)
2030: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_completed,
2031: l_DiscreteJob_rec.quantity_completed)
2032: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_scrapped,
2033: l_DiscreteJob_rec.quantity_scrapped)
2034: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.request_id,
2035: l_DiscreteJob_rec.request_id)
2036: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_account,

Line 2034: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.request_id,

2030: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_completed,
2031: l_DiscreteJob_rec.quantity_completed)
2032: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_scrapped,
2033: l_DiscreteJob_rec.quantity_scrapped)
2034: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.request_id,
2035: l_DiscreteJob_rec.request_id)
2036: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_account,
2037: l_DiscreteJob_rec.resource_account)
2038: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_variance_account,

Line 2036: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_account,

2032: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_scrapped,
2033: l_DiscreteJob_rec.quantity_scrapped)
2034: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.request_id,
2035: l_DiscreteJob_rec.request_id)
2036: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_account,
2037: l_DiscreteJob_rec.resource_account)
2038: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_variance_account,
2039: l_DiscreteJob_rec.resource_variance_account)
2040: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_reference_id,

Line 2038: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_variance_account,

2034: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.request_id,
2035: l_DiscreteJob_rec.request_id)
2036: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_account,
2037: l_DiscreteJob_rec.resource_account)
2038: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_variance_account,
2039: l_DiscreteJob_rec.resource_variance_account)
2040: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_reference_id,
2041: l_DiscreteJob_rec.routing_reference_id)
2042: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision,

Line 2040: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_reference_id,

2036: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_account,
2037: l_DiscreteJob_rec.resource_account)
2038: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_variance_account,
2039: l_DiscreteJob_rec.resource_variance_account)
2040: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_reference_id,
2041: l_DiscreteJob_rec.routing_reference_id)
2042: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision,
2043: l_DiscreteJob_rec.routing_revision)
2044: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision_date,

Line 2042: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision,

2038: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_variance_account,
2039: l_DiscreteJob_rec.resource_variance_account)
2040: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_reference_id,
2041: l_DiscreteJob_rec.routing_reference_id)
2042: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision,
2043: l_DiscreteJob_rec.routing_revision)
2044: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision_date,
2045: l_DiscreteJob_rec.routing_revision_date)
2046: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_completion_date,

Line 2044: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision_date,

2040: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_reference_id,
2041: l_DiscreteJob_rec.routing_reference_id)
2042: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision,
2043: l_DiscreteJob_rec.routing_revision)
2044: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision_date,
2045: l_DiscreteJob_rec.routing_revision_date)
2046: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_completion_date,
2047: l_DiscreteJob_rec.scheduled_completion_date)
2048: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_start_date,

Line 2046: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_completion_date,

2042: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision,
2043: l_DiscreteJob_rec.routing_revision)
2044: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision_date,
2045: l_DiscreteJob_rec.routing_revision_date)
2046: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_completion_date,
2047: l_DiscreteJob_rec.scheduled_completion_date)
2048: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_start_date,
2049: l_DiscreteJob_rec.scheduled_start_date)
2050: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.schedule_group_id,

Line 2048: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_start_date,

2044: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision_date,
2045: l_DiscreteJob_rec.routing_revision_date)
2046: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_completion_date,
2047: l_DiscreteJob_rec.scheduled_completion_date)
2048: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_start_date,
2049: l_DiscreteJob_rec.scheduled_start_date)
2050: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.schedule_group_id,
2051: l_DiscreteJob_rec.schedule_group_id)
2052: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_code,

Line 2050: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.schedule_group_id,

2046: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_completion_date,
2047: l_DiscreteJob_rec.scheduled_completion_date)
2048: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_start_date,
2049: l_DiscreteJob_rec.scheduled_start_date)
2050: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.schedule_group_id,
2051: l_DiscreteJob_rec.schedule_group_id)
2052: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_code,
2053: l_DiscreteJob_rec.source_code)
2054: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_line_id,

Line 2052: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_code,

2048: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_start_date,
2049: l_DiscreteJob_rec.scheduled_start_date)
2050: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.schedule_group_id,
2051: l_DiscreteJob_rec.schedule_group_id)
2052: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_code,
2053: l_DiscreteJob_rec.source_code)
2054: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_line_id,
2055: l_DiscreteJob_rec.source_line_id)
2056: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.start_quantity,

Line 2054: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_line_id,

2050: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.schedule_group_id,
2051: l_DiscreteJob_rec.schedule_group_id)
2052: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_code,
2053: l_DiscreteJob_rec.source_code)
2054: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_line_id,
2055: l_DiscreteJob_rec.source_line_id)
2056: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.start_quantity,
2057: l_DiscreteJob_rec.start_quantity)
2058: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.status_type,

Line 2056: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.start_quantity,

2052: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_code,
2053: l_DiscreteJob_rec.source_code)
2054: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_line_id,
2055: l_DiscreteJob_rec.source_line_id)
2056: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.start_quantity,
2057: l_DiscreteJob_rec.start_quantity)
2058: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.status_type,
2059: l_DiscreteJob_rec.status_type)
2060: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.std_cost_adj_account,

Line 2058: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.status_type,

2054: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_line_id,
2055: l_DiscreteJob_rec.source_line_id)
2056: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.start_quantity,
2057: l_DiscreteJob_rec.start_quantity)
2058: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.status_type,
2059: l_DiscreteJob_rec.status_type)
2060: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.std_cost_adj_account,
2061: l_DiscreteJob_rec.std_cost_adj_account)
2062: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.task_id,

Line 2060: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.std_cost_adj_account,

2056: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.start_quantity,
2057: l_DiscreteJob_rec.start_quantity)
2058: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.status_type,
2059: l_DiscreteJob_rec.status_type)
2060: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.std_cost_adj_account,
2061: l_DiscreteJob_rec.std_cost_adj_account)
2062: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.task_id,
2063: l_DiscreteJob_rec.task_id)
2064: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_entity_id,

Line 2062: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.task_id,

2058: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.status_type,
2059: l_DiscreteJob_rec.status_type)
2060: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.std_cost_adj_account,
2061: l_DiscreteJob_rec.std_cost_adj_account)
2062: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.task_id,
2063: l_DiscreteJob_rec.task_id)
2064: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_entity_id,
2065: l_DiscreteJob_rec.wip_entity_id)
2066: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_supply_type,

Line 2064: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_entity_id,

2060: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.std_cost_adj_account,
2061: l_DiscreteJob_rec.std_cost_adj_account)
2062: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.task_id,
2063: l_DiscreteJob_rec.task_id)
2064: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_entity_id,
2065: l_DiscreteJob_rec.wip_entity_id)
2066: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_supply_type,
2067: l_DiscreteJob_rec.wip_supply_type)
2068: THEN

Line 2066: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_supply_type,

2062: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.task_id,
2063: l_DiscreteJob_rec.task_id)
2064: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_entity_id,
2065: l_DiscreteJob_rec.wip_entity_id)
2066: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_supply_type,
2067: l_DiscreteJob_rec.wip_supply_type)
2068: THEN
2069:
2070: -- Row has not changed. Set out parameter.

Line 2145: IF WIP_GLOBALS.Equal(p_DiscreteJob_rec1.alternate_bom_designator,

2141: RETURN BOOLEAN
2142: IS
2143: BEGIN
2144:
2145: IF WIP_GLOBALS.Equal(p_DiscreteJob_rec1.alternate_bom_designator,
2146: p_DiscreteJob_rec2.alternate_bom_designator)
2147: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.alternate_rout_designator,
2148: p_DiscreteJob_rec2.alternate_rout_designator)
2149: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute1,

Line 2147: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.alternate_rout_designator,

2143: BEGIN
2144:
2145: IF WIP_GLOBALS.Equal(p_DiscreteJob_rec1.alternate_bom_designator,
2146: p_DiscreteJob_rec2.alternate_bom_designator)
2147: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.alternate_rout_designator,
2148: p_DiscreteJob_rec2.alternate_rout_designator)
2149: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute1,
2150: p_DiscreteJob_rec2.attribute1)
2151: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute10,

Line 2149: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute1,

2145: IF WIP_GLOBALS.Equal(p_DiscreteJob_rec1.alternate_bom_designator,
2146: p_DiscreteJob_rec2.alternate_bom_designator)
2147: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.alternate_rout_designator,
2148: p_DiscreteJob_rec2.alternate_rout_designator)
2149: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute1,
2150: p_DiscreteJob_rec2.attribute1)
2151: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute10,
2152: p_DiscreteJob_rec2.attribute10)
2153: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute11,

Line 2151: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute10,

2147: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.alternate_rout_designator,
2148: p_DiscreteJob_rec2.alternate_rout_designator)
2149: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute1,
2150: p_DiscreteJob_rec2.attribute1)
2151: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute10,
2152: p_DiscreteJob_rec2.attribute10)
2153: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute11,
2154: p_DiscreteJob_rec2.attribute11)
2155: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute12,

Line 2153: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute11,

2149: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute1,
2150: p_DiscreteJob_rec2.attribute1)
2151: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute10,
2152: p_DiscreteJob_rec2.attribute10)
2153: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute11,
2154: p_DiscreteJob_rec2.attribute11)
2155: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute12,
2156: p_DiscreteJob_rec2.attribute12)
2157: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute13,

Line 2155: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute12,

2151: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute10,
2152: p_DiscreteJob_rec2.attribute10)
2153: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute11,
2154: p_DiscreteJob_rec2.attribute11)
2155: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute12,
2156: p_DiscreteJob_rec2.attribute12)
2157: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute13,
2158: p_DiscreteJob_rec2.attribute13)
2159: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute14,

Line 2157: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute13,

2153: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute11,
2154: p_DiscreteJob_rec2.attribute11)
2155: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute12,
2156: p_DiscreteJob_rec2.attribute12)
2157: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute13,
2158: p_DiscreteJob_rec2.attribute13)
2159: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute14,
2160: p_DiscreteJob_rec2.attribute14)
2161: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute15,

Line 2159: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute14,

2155: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute12,
2156: p_DiscreteJob_rec2.attribute12)
2157: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute13,
2158: p_DiscreteJob_rec2.attribute13)
2159: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute14,
2160: p_DiscreteJob_rec2.attribute14)
2161: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute15,
2162: p_DiscreteJob_rec2.attribute15)
2163: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute2,

Line 2161: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute15,

2157: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute13,
2158: p_DiscreteJob_rec2.attribute13)
2159: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute14,
2160: p_DiscreteJob_rec2.attribute14)
2161: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute15,
2162: p_DiscreteJob_rec2.attribute15)
2163: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute2,
2164: p_DiscreteJob_rec2.attribute2)
2165: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute3,

Line 2163: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute2,

2159: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute14,
2160: p_DiscreteJob_rec2.attribute14)
2161: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute15,
2162: p_DiscreteJob_rec2.attribute15)
2163: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute2,
2164: p_DiscreteJob_rec2.attribute2)
2165: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute3,
2166: p_DiscreteJob_rec2.attribute3)
2167: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute4,

Line 2165: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute3,

2161: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute15,
2162: p_DiscreteJob_rec2.attribute15)
2163: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute2,
2164: p_DiscreteJob_rec2.attribute2)
2165: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute3,
2166: p_DiscreteJob_rec2.attribute3)
2167: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute4,
2168: p_DiscreteJob_rec2.attribute4)
2169: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute5,

Line 2167: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute4,

2163: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute2,
2164: p_DiscreteJob_rec2.attribute2)
2165: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute3,
2166: p_DiscreteJob_rec2.attribute3)
2167: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute4,
2168: p_DiscreteJob_rec2.attribute4)
2169: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute5,
2170: p_DiscreteJob_rec2.attribute5)
2171: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute6,

Line 2169: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute5,

2165: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute3,
2166: p_DiscreteJob_rec2.attribute3)
2167: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute4,
2168: p_DiscreteJob_rec2.attribute4)
2169: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute5,
2170: p_DiscreteJob_rec2.attribute5)
2171: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute6,
2172: p_DiscreteJob_rec2.attribute6)
2173: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute7,

Line 2171: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute6,

2167: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute4,
2168: p_DiscreteJob_rec2.attribute4)
2169: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute5,
2170: p_DiscreteJob_rec2.attribute5)
2171: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute6,
2172: p_DiscreteJob_rec2.attribute6)
2173: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute7,
2174: p_DiscreteJob_rec2.attribute7)
2175: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute8,

Line 2173: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute7,

2169: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute5,
2170: p_DiscreteJob_rec2.attribute5)
2171: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute6,
2172: p_DiscreteJob_rec2.attribute6)
2173: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute7,
2174: p_DiscreteJob_rec2.attribute7)
2175: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute8,
2176: p_DiscreteJob_rec2.attribute8)
2177: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute9,

Line 2175: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute8,

2171: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute6,
2172: p_DiscreteJob_rec2.attribute6)
2173: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute7,
2174: p_DiscreteJob_rec2.attribute7)
2175: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute8,
2176: p_DiscreteJob_rec2.attribute8)
2177: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute9,
2178: p_DiscreteJob_rec2.attribute9)
2179: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute_category,

Line 2177: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute9,

2173: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute7,
2174: p_DiscreteJob_rec2.attribute7)
2175: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute8,
2176: p_DiscreteJob_rec2.attribute8)
2177: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute9,
2178: p_DiscreteJob_rec2.attribute9)
2179: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute_category,
2180: p_DiscreteJob_rec2.attribute_category)
2181: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_reference_id,

Line 2179: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute_category,

2175: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute8,
2176: p_DiscreteJob_rec2.attribute8)
2177: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute9,
2178: p_DiscreteJob_rec2.attribute9)
2179: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute_category,
2180: p_DiscreteJob_rec2.attribute_category)
2181: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_reference_id,
2182: p_DiscreteJob_rec2.bom_reference_id)
2183: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision,

Line 2181: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_reference_id,

2177: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute9,
2178: p_DiscreteJob_rec2.attribute9)
2179: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute_category,
2180: p_DiscreteJob_rec2.attribute_category)
2181: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_reference_id,
2182: p_DiscreteJob_rec2.bom_reference_id)
2183: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision,
2184: p_DiscreteJob_rec2.bom_revision)
2185: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision_date,

Line 2183: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision,

2179: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute_category,
2180: p_DiscreteJob_rec2.attribute_category)
2181: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_reference_id,
2182: p_DiscreteJob_rec2.bom_reference_id)
2183: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision,
2184: p_DiscreteJob_rec2.bom_revision)
2185: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision_date,
2186: p_DiscreteJob_rec2.bom_revision_date)
2187: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.build_sequence,

Line 2185: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision_date,

2181: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_reference_id,
2182: p_DiscreteJob_rec2.bom_reference_id)
2183: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision,
2184: p_DiscreteJob_rec2.bom_revision)
2185: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision_date,
2186: p_DiscreteJob_rec2.bom_revision_date)
2187: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.build_sequence,
2188: p_DiscreteJob_rec2.build_sequence)
2189: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.class_code,

Line 2187: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.build_sequence,

2183: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision,
2184: p_DiscreteJob_rec2.bom_revision)
2185: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision_date,
2186: p_DiscreteJob_rec2.bom_revision_date)
2187: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.build_sequence,
2188: p_DiscreteJob_rec2.build_sequence)
2189: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.class_code,
2190: p_DiscreteJob_rec2.class_code)
2191: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_bom_sequence_id,

Line 2189: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.class_code,

2185: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision_date,
2186: p_DiscreteJob_rec2.bom_revision_date)
2187: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.build_sequence,
2188: p_DiscreteJob_rec2.build_sequence)
2189: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.class_code,
2190: p_DiscreteJob_rec2.class_code)
2191: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_bom_sequence_id,
2192: p_DiscreteJob_rec2.common_bom_sequence_id)
2193: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_rout_sequence_id,

Line 2191: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_bom_sequence_id,

2187: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.build_sequence,
2188: p_DiscreteJob_rec2.build_sequence)
2189: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.class_code,
2190: p_DiscreteJob_rec2.class_code)
2191: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_bom_sequence_id,
2192: p_DiscreteJob_rec2.common_bom_sequence_id)
2193: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_rout_sequence_id,
2194: p_DiscreteJob_rec2.common_rout_sequence_id)
2195: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_locator_id,

Line 2193: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_rout_sequence_id,

2189: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.class_code,
2190: p_DiscreteJob_rec2.class_code)
2191: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_bom_sequence_id,
2192: p_DiscreteJob_rec2.common_bom_sequence_id)
2193: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_rout_sequence_id,
2194: p_DiscreteJob_rec2.common_rout_sequence_id)
2195: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_locator_id,
2196: p_DiscreteJob_rec2.completion_locator_id)
2197: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_subinventory,

Line 2195: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_locator_id,

2191: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_bom_sequence_id,
2192: p_DiscreteJob_rec2.common_bom_sequence_id)
2193: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_rout_sequence_id,
2194: p_DiscreteJob_rec2.common_rout_sequence_id)
2195: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_locator_id,
2196: p_DiscreteJob_rec2.completion_locator_id)
2197: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_subinventory,
2198: p_DiscreteJob_rec2.completion_subinventory)
2199: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.created_by,

Line 2197: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_subinventory,

2193: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_rout_sequence_id,
2194: p_DiscreteJob_rec2.common_rout_sequence_id)
2195: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_locator_id,
2196: p_DiscreteJob_rec2.completion_locator_id)
2197: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_subinventory,
2198: p_DiscreteJob_rec2.completion_subinventory)
2199: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.created_by,
2200: p_DiscreteJob_rec2.created_by)
2201: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.creation_date,

Line 2199: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.created_by,

2195: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_locator_id,
2196: p_DiscreteJob_rec2.completion_locator_id)
2197: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_subinventory,
2198: p_DiscreteJob_rec2.completion_subinventory)
2199: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.created_by,
2200: p_DiscreteJob_rec2.created_by)
2201: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.creation_date,
2202: p_DiscreteJob_rec2.creation_date)
2203: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_closed,

Line 2201: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.creation_date,

2197: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_subinventory,
2198: p_DiscreteJob_rec2.completion_subinventory)
2199: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.created_by,
2200: p_DiscreteJob_rec2.created_by)
2201: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.creation_date,
2202: p_DiscreteJob_rec2.creation_date)
2203: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_closed,
2204: p_DiscreteJob_rec2.date_closed)
2205: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_completed,

Line 2203: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_closed,

2199: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.created_by,
2200: p_DiscreteJob_rec2.created_by)
2201: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.creation_date,
2202: p_DiscreteJob_rec2.creation_date)
2203: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_closed,
2204: p_DiscreteJob_rec2.date_closed)
2205: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_completed,
2206: p_DiscreteJob_rec2.date_completed)
2207: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_released,

Line 2205: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_completed,

2201: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.creation_date,
2202: p_DiscreteJob_rec2.creation_date)
2203: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_closed,
2204: p_DiscreteJob_rec2.date_closed)
2205: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_completed,
2206: p_DiscreteJob_rec2.date_completed)
2207: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_released,
2208: p_DiscreteJob_rec2.date_released)
2209: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.demand_class,

Line 2207: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_released,

2203: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_closed,
2204: p_DiscreteJob_rec2.date_closed)
2205: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_completed,
2206: p_DiscreteJob_rec2.date_completed)
2207: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_released,
2208: p_DiscreteJob_rec2.date_released)
2209: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.demand_class,
2210: p_DiscreteJob_rec2.demand_class)
2211: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.description,

Line 2209: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.demand_class,

2205: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_completed,
2206: p_DiscreteJob_rec2.date_completed)
2207: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_released,
2208: p_DiscreteJob_rec2.date_released)
2209: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.demand_class,
2210: p_DiscreteJob_rec2.demand_class)
2211: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.description,
2212: p_DiscreteJob_rec2.description)
2213: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.firm_planned_flag,

Line 2211: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.description,

2207: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_released,
2208: p_DiscreteJob_rec2.date_released)
2209: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.demand_class,
2210: p_DiscreteJob_rec2.demand_class)
2211: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.description,
2212: p_DiscreteJob_rec2.description)
2213: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.firm_planned_flag,
2214: p_DiscreteJob_rec2.firm_planned_flag)
2215: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.job_type,

Line 2213: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.firm_planned_flag,

2209: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.demand_class,
2210: p_DiscreteJob_rec2.demand_class)
2211: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.description,
2212: p_DiscreteJob_rec2.description)
2213: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.firm_planned_flag,
2214: p_DiscreteJob_rec2.firm_planned_flag)
2215: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.job_type,
2216: p_DiscreteJob_rec2.job_type)
2217: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.kanban_card_id,

Line 2215: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.job_type,

2211: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.description,
2212: p_DiscreteJob_rec2.description)
2213: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.firm_planned_flag,
2214: p_DiscreteJob_rec2.firm_planned_flag)
2215: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.job_type,
2216: p_DiscreteJob_rec2.job_type)
2217: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.kanban_card_id,
2218: p_DiscreteJob_rec2.kanban_card_id)
2219: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_updated_by,

Line 2217: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.kanban_card_id,

2213: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.firm_planned_flag,
2214: p_DiscreteJob_rec2.firm_planned_flag)
2215: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.job_type,
2216: p_DiscreteJob_rec2.job_type)
2217: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.kanban_card_id,
2218: p_DiscreteJob_rec2.kanban_card_id)
2219: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_updated_by,
2220: p_DiscreteJob_rec2.last_updated_by)
2221: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_date,

Line 2219: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_updated_by,

2215: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.job_type,
2216: p_DiscreteJob_rec2.job_type)
2217: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.kanban_card_id,
2218: p_DiscreteJob_rec2.kanban_card_id)
2219: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_updated_by,
2220: p_DiscreteJob_rec2.last_updated_by)
2221: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_date,
2222: p_DiscreteJob_rec2.last_update_date)
2223: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_login,

Line 2221: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_date,

2217: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.kanban_card_id,
2218: p_DiscreteJob_rec2.kanban_card_id)
2219: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_updated_by,
2220: p_DiscreteJob_rec2.last_updated_by)
2221: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_date,
2222: p_DiscreteJob_rec2.last_update_date)
2223: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_login,
2224: p_DiscreteJob_rec2.last_update_login)
2225: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.line_id,

Line 2223: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_login,

2219: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_updated_by,
2220: p_DiscreteJob_rec2.last_updated_by)
2221: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_date,
2222: p_DiscreteJob_rec2.last_update_date)
2223: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_login,
2224: p_DiscreteJob_rec2.last_update_login)
2225: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.line_id,
2226: p_DiscreteJob_rec2.line_id)
2227: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.lot_number,

Line 2225: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.line_id,

2221: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_date,
2222: p_DiscreteJob_rec2.last_update_date)
2223: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_login,
2224: p_DiscreteJob_rec2.last_update_login)
2225: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.line_id,
2226: p_DiscreteJob_rec2.line_id)
2227: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.lot_number,
2228: p_DiscreteJob_rec2.lot_number)
2229: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_account,

Line 2227: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.lot_number,

2223: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_login,
2224: p_DiscreteJob_rec2.last_update_login)
2225: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.line_id,
2226: p_DiscreteJob_rec2.line_id)
2227: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.lot_number,
2228: p_DiscreteJob_rec2.lot_number)
2229: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_account,
2230: p_DiscreteJob_rec2.material_account)
2231: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_overhead_account,

Line 2229: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_account,

2225: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.line_id,
2226: p_DiscreteJob_rec2.line_id)
2227: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.lot_number,
2228: p_DiscreteJob_rec2.lot_number)
2229: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_account,
2230: p_DiscreteJob_rec2.material_account)
2231: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_overhead_account,
2232: p_DiscreteJob_rec2.material_overhead_account)
2233: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_variance_account,

Line 2231: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_overhead_account,

2227: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.lot_number,
2228: p_DiscreteJob_rec2.lot_number)
2229: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_account,
2230: p_DiscreteJob_rec2.material_account)
2231: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_overhead_account,
2232: p_DiscreteJob_rec2.material_overhead_account)
2233: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_variance_account,
2234: p_DiscreteJob_rec2.material_variance_account)
2235: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_net_quantity,

Line 2233: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_variance_account,

2229: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_account,
2230: p_DiscreteJob_rec2.material_account)
2231: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_overhead_account,
2232: p_DiscreteJob_rec2.material_overhead_account)
2233: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_variance_account,
2234: p_DiscreteJob_rec2.material_variance_account)
2235: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_net_quantity,
2236: p_DiscreteJob_rec2.mps_net_quantity)
2237: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_scheduled_cpl_date,

Line 2235: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_net_quantity,

2231: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_overhead_account,
2232: p_DiscreteJob_rec2.material_overhead_account)
2233: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_variance_account,
2234: p_DiscreteJob_rec2.material_variance_account)
2235: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_net_quantity,
2236: p_DiscreteJob_rec2.mps_net_quantity)
2237: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_scheduled_cpl_date,
2238: p_DiscreteJob_rec2.mps_scheduled_cpl_date)
2239: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.net_quantity,

Line 2237: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_scheduled_cpl_date,

2233: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_variance_account,
2234: p_DiscreteJob_rec2.material_variance_account)
2235: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_net_quantity,
2236: p_DiscreteJob_rec2.mps_net_quantity)
2237: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_scheduled_cpl_date,
2238: p_DiscreteJob_rec2.mps_scheduled_cpl_date)
2239: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.net_quantity,
2240: p_DiscreteJob_rec2.net_quantity)
2241: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.organization_id,

Line 2239: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.net_quantity,

2235: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_net_quantity,
2236: p_DiscreteJob_rec2.mps_net_quantity)
2237: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_scheduled_cpl_date,
2238: p_DiscreteJob_rec2.mps_scheduled_cpl_date)
2239: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.net_quantity,
2240: p_DiscreteJob_rec2.net_quantity)
2241: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.organization_id,
2242: p_DiscreteJob_rec2.organization_id)
2243: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_account,

Line 2241: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.organization_id,

2237: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_scheduled_cpl_date,
2238: p_DiscreteJob_rec2.mps_scheduled_cpl_date)
2239: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.net_quantity,
2240: p_DiscreteJob_rec2.net_quantity)
2241: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.organization_id,
2242: p_DiscreteJob_rec2.organization_id)
2243: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_account,
2244: p_DiscreteJob_rec2.osp_account)
2245: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_variance_account,

Line 2243: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_account,

2239: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.net_quantity,
2240: p_DiscreteJob_rec2.net_quantity)
2241: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.organization_id,
2242: p_DiscreteJob_rec2.organization_id)
2243: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_account,
2244: p_DiscreteJob_rec2.osp_account)
2245: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_variance_account,
2246: p_DiscreteJob_rec2.osp_variance_account)
2247: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_type,

Line 2245: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_variance_account,

2241: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.organization_id,
2242: p_DiscreteJob_rec2.organization_id)
2243: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_account,
2244: p_DiscreteJob_rec2.osp_account)
2245: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_variance_account,
2246: p_DiscreteJob_rec2.osp_variance_account)
2247: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_type,
2248: p_DiscreteJob_rec2.overcpl_tolerance_type)
2249: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_value,

Line 2247: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_type,

2243: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_account,
2244: p_DiscreteJob_rec2.osp_account)
2245: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_variance_account,
2246: p_DiscreteJob_rec2.osp_variance_account)
2247: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_type,
2248: p_DiscreteJob_rec2.overcpl_tolerance_type)
2249: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_value,
2250: p_DiscreteJob_rec2.overcpl_tolerance_value)
2251: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_account,

Line 2249: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_value,

2245: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_variance_account,
2246: p_DiscreteJob_rec2.osp_variance_account)
2247: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_type,
2248: p_DiscreteJob_rec2.overcpl_tolerance_type)
2249: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_value,
2250: p_DiscreteJob_rec2.overcpl_tolerance_value)
2251: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_account,
2252: p_DiscreteJob_rec2.overhead_account)
2253: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_variance_account,

Line 2251: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_account,

2247: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_type,
2248: p_DiscreteJob_rec2.overcpl_tolerance_type)
2249: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_value,
2250: p_DiscreteJob_rec2.overcpl_tolerance_value)
2251: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_account,
2252: p_DiscreteJob_rec2.overhead_account)
2253: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_variance_account,
2254: p_DiscreteJob_rec2.overhead_variance_account)
2255: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.primary_item_id,

Line 2253: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_variance_account,

2249: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_value,
2250: p_DiscreteJob_rec2.overcpl_tolerance_value)
2251: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_account,
2252: p_DiscreteJob_rec2.overhead_account)
2253: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_variance_account,
2254: p_DiscreteJob_rec2.overhead_variance_account)
2255: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.primary_item_id,
2256: p_DiscreteJob_rec2.primary_item_id)
2257: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_application_id,

Line 2255: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.primary_item_id,

2251: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_account,
2252: p_DiscreteJob_rec2.overhead_account)
2253: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_variance_account,
2254: p_DiscreteJob_rec2.overhead_variance_account)
2255: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.primary_item_id,
2256: p_DiscreteJob_rec2.primary_item_id)
2257: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_application_id,
2258: p_DiscreteJob_rec2.program_application_id)
2259: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_id,

Line 2257: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_application_id,

2253: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_variance_account,
2254: p_DiscreteJob_rec2.overhead_variance_account)
2255: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.primary_item_id,
2256: p_DiscreteJob_rec2.primary_item_id)
2257: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_application_id,
2258: p_DiscreteJob_rec2.program_application_id)
2259: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_id,
2260: p_DiscreteJob_rec2.program_id)
2261: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_update_date,

Line 2259: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_id,

2255: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.primary_item_id,
2256: p_DiscreteJob_rec2.primary_item_id)
2257: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_application_id,
2258: p_DiscreteJob_rec2.program_application_id)
2259: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_id,
2260: p_DiscreteJob_rec2.program_id)
2261: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_update_date,
2262: p_DiscreteJob_rec2.program_update_date)
2263: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_costed,

Line 2261: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_update_date,

2257: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_application_id,
2258: p_DiscreteJob_rec2.program_application_id)
2259: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_id,
2260: p_DiscreteJob_rec2.program_id)
2261: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_update_date,
2262: p_DiscreteJob_rec2.program_update_date)
2263: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_costed,
2264: p_DiscreteJob_rec2.project_costed)
2265: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_id,

Line 2263: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_costed,

2259: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_id,
2260: p_DiscreteJob_rec2.program_id)
2261: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_update_date,
2262: p_DiscreteJob_rec2.program_update_date)
2263: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_costed,
2264: p_DiscreteJob_rec2.project_costed)
2265: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_id,
2266: p_DiscreteJob_rec2.project_id)
2267: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_completed,

Line 2265: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_id,

2261: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_update_date,
2262: p_DiscreteJob_rec2.program_update_date)
2263: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_costed,
2264: p_DiscreteJob_rec2.project_costed)
2265: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_id,
2266: p_DiscreteJob_rec2.project_id)
2267: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_completed,
2268: p_DiscreteJob_rec2.quantity_completed)
2269: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_scrapped,

Line 2267: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_completed,

2263: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_costed,
2264: p_DiscreteJob_rec2.project_costed)
2265: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_id,
2266: p_DiscreteJob_rec2.project_id)
2267: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_completed,
2268: p_DiscreteJob_rec2.quantity_completed)
2269: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_scrapped,
2270: p_DiscreteJob_rec2.quantity_scrapped)
2271: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.request_id,

Line 2269: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_scrapped,

2265: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_id,
2266: p_DiscreteJob_rec2.project_id)
2267: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_completed,
2268: p_DiscreteJob_rec2.quantity_completed)
2269: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_scrapped,
2270: p_DiscreteJob_rec2.quantity_scrapped)
2271: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.request_id,
2272: p_DiscreteJob_rec2.request_id)
2273: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_account,

Line 2271: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.request_id,

2267: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_completed,
2268: p_DiscreteJob_rec2.quantity_completed)
2269: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_scrapped,
2270: p_DiscreteJob_rec2.quantity_scrapped)
2271: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.request_id,
2272: p_DiscreteJob_rec2.request_id)
2273: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_account,
2274: p_DiscreteJob_rec2.resource_account)
2275: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_variance_account,

Line 2273: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_account,

2269: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_scrapped,
2270: p_DiscreteJob_rec2.quantity_scrapped)
2271: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.request_id,
2272: p_DiscreteJob_rec2.request_id)
2273: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_account,
2274: p_DiscreteJob_rec2.resource_account)
2275: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_variance_account,
2276: p_DiscreteJob_rec2.resource_variance_account)
2277: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_reference_id,

Line 2275: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_variance_account,

2271: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.request_id,
2272: p_DiscreteJob_rec2.request_id)
2273: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_account,
2274: p_DiscreteJob_rec2.resource_account)
2275: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_variance_account,
2276: p_DiscreteJob_rec2.resource_variance_account)
2277: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_reference_id,
2278: p_DiscreteJob_rec2.routing_reference_id)
2279: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision,

Line 2277: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_reference_id,

2273: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_account,
2274: p_DiscreteJob_rec2.resource_account)
2275: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_variance_account,
2276: p_DiscreteJob_rec2.resource_variance_account)
2277: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_reference_id,
2278: p_DiscreteJob_rec2.routing_reference_id)
2279: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision,
2280: p_DiscreteJob_rec2.routing_revision)
2281: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision_date,

Line 2279: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision,

2275: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_variance_account,
2276: p_DiscreteJob_rec2.resource_variance_account)
2277: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_reference_id,
2278: p_DiscreteJob_rec2.routing_reference_id)
2279: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision,
2280: p_DiscreteJob_rec2.routing_revision)
2281: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision_date,
2282: p_DiscreteJob_rec2.routing_revision_date)
2283: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_completion_date,

Line 2281: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision_date,

2277: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_reference_id,
2278: p_DiscreteJob_rec2.routing_reference_id)
2279: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision,
2280: p_DiscreteJob_rec2.routing_revision)
2281: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision_date,
2282: p_DiscreteJob_rec2.routing_revision_date)
2283: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_completion_date,
2284: p_DiscreteJob_rec2.scheduled_completion_date)
2285: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_start_date,

Line 2283: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_completion_date,

2279: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision,
2280: p_DiscreteJob_rec2.routing_revision)
2281: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision_date,
2282: p_DiscreteJob_rec2.routing_revision_date)
2283: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_completion_date,
2284: p_DiscreteJob_rec2.scheduled_completion_date)
2285: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_start_date,
2286: p_DiscreteJob_rec2.scheduled_start_date)
2287: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.schedule_group_id,

Line 2285: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_start_date,

2281: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision_date,
2282: p_DiscreteJob_rec2.routing_revision_date)
2283: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_completion_date,
2284: p_DiscreteJob_rec2.scheduled_completion_date)
2285: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_start_date,
2286: p_DiscreteJob_rec2.scheduled_start_date)
2287: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.schedule_group_id,
2288: p_DiscreteJob_rec2.schedule_group_id)
2289: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_code,

Line 2287: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.schedule_group_id,

2283: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_completion_date,
2284: p_DiscreteJob_rec2.scheduled_completion_date)
2285: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_start_date,
2286: p_DiscreteJob_rec2.scheduled_start_date)
2287: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.schedule_group_id,
2288: p_DiscreteJob_rec2.schedule_group_id)
2289: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_code,
2290: p_DiscreteJob_rec2.source_code)
2291: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_line_id,

Line 2289: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_code,

2285: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_start_date,
2286: p_DiscreteJob_rec2.scheduled_start_date)
2287: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.schedule_group_id,
2288: p_DiscreteJob_rec2.schedule_group_id)
2289: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_code,
2290: p_DiscreteJob_rec2.source_code)
2291: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_line_id,
2292: p_DiscreteJob_rec2.source_line_id)
2293: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.start_quantity,

Line 2291: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_line_id,

2287: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.schedule_group_id,
2288: p_DiscreteJob_rec2.schedule_group_id)
2289: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_code,
2290: p_DiscreteJob_rec2.source_code)
2291: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_line_id,
2292: p_DiscreteJob_rec2.source_line_id)
2293: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.start_quantity,
2294: p_DiscreteJob_rec2.start_quantity)
2295: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.status_type,

Line 2293: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.start_quantity,

2289: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_code,
2290: p_DiscreteJob_rec2.source_code)
2291: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_line_id,
2292: p_DiscreteJob_rec2.source_line_id)
2293: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.start_quantity,
2294: p_DiscreteJob_rec2.start_quantity)
2295: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.status_type,
2296: p_DiscreteJob_rec2.status_type)
2297: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.std_cost_adj_account,

Line 2295: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.status_type,

2291: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_line_id,
2292: p_DiscreteJob_rec2.source_line_id)
2293: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.start_quantity,
2294: p_DiscreteJob_rec2.start_quantity)
2295: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.status_type,
2296: p_DiscreteJob_rec2.status_type)
2297: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.std_cost_adj_account,
2298: p_DiscreteJob_rec2.std_cost_adj_account)
2299: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.task_id,

Line 2297: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.std_cost_adj_account,

2293: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.start_quantity,
2294: p_DiscreteJob_rec2.start_quantity)
2295: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.status_type,
2296: p_DiscreteJob_rec2.status_type)
2297: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.std_cost_adj_account,
2298: p_DiscreteJob_rec2.std_cost_adj_account)
2299: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.task_id,
2300: p_DiscreteJob_rec2.task_id)
2301: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_entity_id,

Line 2299: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.task_id,

2295: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.status_type,
2296: p_DiscreteJob_rec2.status_type)
2297: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.std_cost_adj_account,
2298: p_DiscreteJob_rec2.std_cost_adj_account)
2299: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.task_id,
2300: p_DiscreteJob_rec2.task_id)
2301: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_entity_id,
2302: p_DiscreteJob_rec2.wip_entity_id)
2303: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_supply_type,

Line 2301: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_entity_id,

2297: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.std_cost_adj_account,
2298: p_DiscreteJob_rec2.std_cost_adj_account)
2299: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.task_id,
2300: p_DiscreteJob_rec2.task_id)
2301: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_entity_id,
2302: p_DiscreteJob_rec2.wip_entity_id)
2303: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_supply_type,
2304: p_DiscreteJob_rec2.wip_supply_type)
2305: THEN

Line 2303: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_supply_type,

2299: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.task_id,
2300: p_DiscreteJob_rec2.task_id)
2301: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_entity_id,
2302: p_DiscreteJob_rec2.wip_entity_id)
2303: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_supply_type,
2304: p_DiscreteJob_rec2.wip_supply_type)
2305: THEN
2306: RETURN TRUE;
2307: ELSE